Help
 

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

Help
 

Monty Wrote:
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


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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=564628

Help
 

Cheers

"Dav" wrote:


Monty Wrote:
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


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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=564628