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?
=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?