The formula definitely returns the correct amount. Can you post the
exact formula you're using?

In article ,
oomyoo wrote:

nope, didn't work...

I should get a value of 6, but I'm only getting 4. Any other ideas?

"Domenic" wrote:

Try...

=SUMIF(A1:C3,"Jim",B1:D3)

Hope this helps!

In article ,
oomyoo wrote:

I have something like this:

A B C D

jim 4 jim 2
cathy 2 cathy 4
mary 5 mary 3

I would like to sum the values in B and D that corresponds to jim. I
tried
=sumproduct((criteria1)*(criteria2)*(range B,D)), but this doesn't work.
Any
help would be much appreciated.

Thanks!