sumif function
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!
|