"Claus Busch" wrote:
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)

Or to simplify:

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

Things to note:

1. You do not need the double negative if you use multiplication in the
arithemetic expression. The purpose of the double negative in this context
is to convert TRUE and FALSE into 1 and 0. But any arithmetic operation
will accomplish that.

2. Separate C1:C20 with a comma (separate parameter), instead of multiplying
it in the arithmetic expression. The effect is the same. The difference
is: SUMPRODUCT can recognize and ignore non-numeric data in C1:C20. When
you multiply C1:C20, Excel's arithmetic expression evaluator does not
tolerate non-numeric data.