SUMIF Formula

[gymwrecker]

The below formula is counting values in the P5:P313 range; since I also have values in Q5:Q313, how can I fix this formula to also count what's in Q5:Q313?

=SUMIF(D5:D313, "GS11", P5:P313)

 

[Joe4]

Are you wanting to do a COUNT or a SUM? For counting, you woudl typically use COUNITF, not SUMIF.

If you want the sum of the ones in column P plus the sum of the ones in column Q, then maybe:

[COLOR=#333333]=SUMIF(D5:D313, "GS11", P5:P313)+[/COLOR][COLOR=#333333]SUMIF(D5:D313, "GS11", Q5:Q313)
[/COLOR]

 

[gymwrecker]

Thank you Joe4, it's working now!!!

 

[Joe4]

You are welcome.