sum if help

  • Thread starter Thread starter ant
  • Start date Start date
A

ant

I have this formula with works great.
=SUMIF($AO$2:$AO10000,AV4,$O$2:$O10000)
so whatever I type into cell "AV3" it will add all the
numbers in o2:010000
However, I also want to add two more criteria's to the
formula


SUMIF($AM$2:$AM10000,AV5,$O$2:$O10000)
&

=SUMIF($AK$2:$AK10000,AV3,$O$2:$O10000)


Is there a way to combine these 3 formulas
 
One way

=SUM(($AO$2:$AO10000=TRANSPOSE(AV3:AV5))*($O$2:$O10000))

entered with ctrl + shift & enter
 
Back
Top