SUMIF Again not working

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

ant

I want to add numbers that meet 3 criteria
For example look through column 1 for "man" that
through column 2 for "22" than trough column 3 for "2003"

So if these three arguments are true and what's in column 4
I have these 3 formulas which all work

=SUMIF($AO$2:$AO10000,AV4,$O$2:$O10000)


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

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

I need a way to combine them.

I already posted this question but I didn't receive an
answer that worked

Please help
 
You didn't state for which range the condition "man" must hold. The same for
the conditions 22 and 2003. Also, are you not making clear where you put
these conditions. Moreover, you omitted to make explicit what you have in
AV3:AV5. The only thing that seems unambiguously clear is the range to sum:
O2:O10000.
 
Hi
Try adding the three together:
=SUMIF($AO$2:$AO10000,AV4,$O$2:$O10000)+SUMIF$AM$2:$AM10000,AV5,$O$2:$O10000
)
+SUMIF($AK$2:$AK10000,AV3,$O$2:$O10000)
 
I have 3 sum if forumals below.

I just want to type 3 critarts in 3 cells and one forumal
will add what im looking for
 
Back
Top