Offset
 

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)

Offset
 

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
---------------
Jacob Skaria


"MichelleT" wrote:

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)

Offset
 

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?
--
David Biddulph

"MichelleT" wrote in message
...
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)