Thanks, that works the best. I have multiple conditions, so the prior does
not work.

"Harlan Grove" wrote:

"Rick Rothstein (MVP - VB)" wrote...
....
=SUMPRODUCT((ID={1340,5450})*Amount)

Which is the best way to do it in this case since ID could only equal one or
the other. More generally, multiple OR conditions could be true, in which
case you'd need

=SUMPRODUCT(--((Condition1)+(Condition2)+...+(ConditionN)0),val ues)