(With Tom's nice suggestion):
=SUMIF(Sheet2!C:C,"Brew",Sheet2!D:D)

Cheers,
--
AP

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

Hi HTH,

Thanks for your quick response.

Extrapulating my earlier question. How do I do the same if the columns
are in a different sheet. How do I reference to a different sheet.

Thanks a lot for your help.
-Kaushik


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