sumif query

[BrutalLogiC]

hey should this sumif work over a number of columns? I'm trying to sum the total of numbers in columns W through to AB.

=sumif(B12:B200,C4,W12:AB200)

sorry if vague!

 

[AhoyNC]

No, the sum range in SUMIF can't work across multiple columns.
Try:

=SUMPRODUCT((B12:B200=C4)*(W12:AB200))

 

[jtakw]

Already addressed, nevermind.

 

[BrutalLogiC]

Thanks, very helpful!

 

[AhoyNC]

You're welcome.