SUMIF Again not working

[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

 

[Aladin Akyurek]

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.

 

[Andy B]

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)

 

[ant]

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