Thread: sumif function
View Single Post
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

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?