i was thinking complicated instead of simple... thanks!

"Bernie Deitrick" wrote:

=SUMIF(A1:A3,"Jim",B1:B3) + SUMIF(C1:C3,"Jim",D1:D3)

HTH,
Bernie
MS Excel MVP


"oomyoo" wrote in message
...
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!