Can I use multiple sum ranges in the SUMIF function?

[Barcode]

Can I use multiple sum ranges in the SUMIF function?

I'm trying to add 3 cells in different ranges in a SUMIF function.

I have tried the following 2 formulas but both give errors:
=SUMIF($F$4:$F$462,"audcad",($Q$4:$Q$462+$M$4:$M$462+$N$4:$N$462))
=SUMIF($F$4:$F$462,"audcad",SUM($Q$4:$Q$462+$M$4:$M$462+$N$4:$N$462))

I have about 30 of these looking for different text.

What am I doing wrong or do I need a different function?

Bob

 

[mikerickson]

SUMIF and similar function, require ranges as their arguments.

Try

=SUMIF(F$4:$F$462,"audcad", $Q$4:$Q$462)+SUMIF(F$4:$F$462,"audcad", $M$4:$M$462)+SUMIF(F$4:$F$462,"audcad", $N$4:$N$462)

 

[Aladin Akyurek]

=SUM(SUMIF($F$4:$F$462,"audcad",$Q$4:$Q$462),SUMIF($F$4:$F$462,"audcad",$M$4:$M$462),SUMIF($F$4:$F$462,"audcad",$N$4:$N$462))

would be an appropriate choice for reasons of efficiency.

Otherwise, control+shift+enter, not just enter:

=SUM(IF($F$4:$F$462,"audcad",$Q$4:$Q$462+$M$4:$M$462+$N$4:$N$462))

 

[Barcode]

Thanks very much mikerickson & Aladin Akyurek. Exactly what I needed. Very much appreciated.

Bob

 

[mikerickson]

Or
SUMPRODUCT(($F$4:$F$462="aucad")*($Q$4:$Q$462+$M$4:$M$462+$N$4:$N$462))