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!




"RagDyer" wrote:

Use a different function ... SumProduct().

=SumProduct((A1:A100=criteria1)*(B1:B100=criteria2 )*C1:C100)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"AHANG JJJ" <AHANG wrote in message
...
What is the syntax for sumif function with two criteria range and two
criteria?