when using autosum and you are adding say C2 to C5 the answer comes up from only C3 to C5 why
Please upload a sample file, where this is happening. My wild guess: C2
is not a number but text and hence treated as 0
(zero).
Even though it looks like a number, it is most likely not a number in the “spreadsheet sense”. If it is internally represented as a string of digits (i.e. number as text), arithmetic functions will count it as “no value”. A formula using arithmetic operators will attempt to translate text operands to numbers.
try =C2+C3+C4+C5
Do you get the same result as with =SUM(C2:C5)
?
More easily: Activate option Edit -> [x] Value Highlighting
(or CTRL+F8
) and if it is not blue colored, it is not a number.
Hi sorry have not been back sooner, just been putting up with it.
No it is definitely a number. The problem most occurs when clicking “sum” with only 3 or 4 figures in the calculation no space between the numbers. It will always miss out the first row C2 above for instance. If you do a longer column it works fine
Please don’t post an answer, if it is not a solution to your initial question. Thank you.
Edit your question or write a comment.