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?