Offset

[MichelleT]

I need to sum the total from column A to D, the number of column is varies
A B C D E F
1 Jan Feb Mar Apr May
2 Sample x x x x x

My formula returns a zero, pls check what's wrong
=sumif(a2:a2,a2,offset(A2:A2,0,5,05)

 

[Jacob Skaria]

Can you elaborate your query..
--Do you mean sum or count ?
--'x' represents numbers or is counted as 1 ?


If this post helps click Yes

 

[David Biddulph]

The first thing that's wrong is that your parentheses don't match, so that's
obviously not the formula which you are using.
Don't try to retype. Copy your formula from the formula bar and paste here.

And your OFFSET formula will return the range F2:F6.

And your SUMIF is looking only at A2 and checking that it is equal to A2,
and will therefore return the value of the first element of the range, in
other words it will return F2. Is that what you wanted?