SUMIF and summing multiple columns

[UHsoccer]

I am using the following formula to sum a single column

=SUMIF(A11:A409,A11,F11:F409) works OK

now I need to sum more than just Column F, I need to extent the summation through to column W, however what I use (below) does not work

=SUMIF(A11:A409,A11,F11:W409)

Anyone can solve this?

 

[fairwinds]

Hi,

Try:

=SUMPRODUCT((A11:A409=A11)*F11:W409)

 

[UHsoccer]

Works fine, thanks