Offset

M

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)
 
J

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
 
D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top