Hi Michelle,

Am Fri, 6 Jan 2012 12:02:46 -0800 (PST) schrieb Michelle:


Thanks. The result I get is #VALUE.

try:
=SUMPRODUCT(--(A1:A20="Open - Active"),--(B1:B20="GVT Invest"),C1:C20)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2