Is that a good description?

Yes

{SUM(AND(cond1, cond2)*sumcolumnvalue)}

AND returns a single result where you need an array of results.

It sounds like you want an OR comparison: sum C if A = x *or* D = y.

Try one of these:

=SUMPRODUCT(--((A1:A10="x")+(D1:D10="y")0),C1:C10)

=SUMPRODUCT(SIGN((A1:A10="x")+(D1:D10="y")),C1:C10 )

--
Biff
Microsoft Excel MVP


"travcoe21" wrote in message
...
Sorry, I meant cond2 and cond3 are never both true for the same
sumcolumnvalue.

Jeff

"travcoe21" wrote:
Note that in order for this to work the way it's supposed to, cond1 and
cond3 must never both be true for the same sumcolumnvalue. Which for my
application is always the case.