More specifically, I'm saying Add the numbers in the range D2:D22 if A2:A22
="Corporate" and If B2:B22 ="Zone4" I don't understand the * reference.

"Don Guillett" wrote:

=sumproduct((a2:a22="Jay")*(b2:b22=1))
to sum c based on that criteria

=sumproduct((a2:a22="Jay")*(b2:b22=1)*c2:c22)
note that the ranges must be the same size and not complete columns
--
Don Guillett
SalesAid Software

"jayceejay" wrote in message
...
I'm trying to use the SumIf Function (as I understand its use) and I keep
running into the same problems -- in many cases I have more than one
criterion for addind a specific cell. Is there a way to modify SumIf to
allow for multiple criteria? I try to do it in the insert function box
and
it gets spit back out at me. Any ideas?

Jay