I agree it is very powerful, but because of the way array formulas perform
(and it performs like an array formula) they can be very slow for large
ranges (I am sure you know that - put just repeating here for completeness).
So for single conditions, I try to use sumif or countif if possible and
leave the heavy lifting for sumproduct or an array formula when required.

--
Regards,
Tom Ogilvy


"Ardus Petus" wrote:

Nice shot, Tom!

Since I discovered SUMPRODUCT, I do everything with it

Cheers,
--
AP

"Tom Ogilvy" a écrit dans le message
de news: ...
If that formula would produce the correct answer, then
Faster would be

=sumif(C:C,"Brew",D:D)

--
Regards,
Tom Ogilvy


"Ardus Petus" wrote:

=SUMPRODUCT(--(C1:C999="Brew"),D1:D999)

HTH
--
AP

"kaushik" a écrit
dans le message de news:
...

Hi,
I'm a newbie to excel,

I need to lookup for a string for ex "Brew" or "Lunch" in column 3 and
find the value of the cell in the same row and column 4. Add all these
values and the sum should be displayed in say g3.

Thanks for all your help


--
kaushik
------------------------------------------------------------------------
kaushik's Profile:
http://www.excelforum.com/member.php...o&userid=34715
View this thread:
http://www.excelforum.com/showthread...hreadid=544812