Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In column (I) I have cost centres, which range from 2001 to 2042 and in
column (H) I have the number of days taken for payment. In cell AA4 and I
want to return all payments over 5 days belonging to cost centres
2033,2036,2037 & 2041.

Can you please help.

Monty
 
Monty said:
In column (I) I have cost centres, which range from 2001 to 2042 and in
column (H) I have the number of days taken for payment. In cell AA4 and
I
want to return all payments over 5 days belonging to cost centres
2033,2036,2037 & 2041.

Can you please help.

Monty
Click to expand...


=SUMPRODUCT((h1:h100>0)*(i1:i100={2033, 2036, 2037, 2041}))

Regards

Dav
 
Back
Top