Forum Discussion
Excel
If I enter a simple formula such as SUM(A1:A7), it gives me the wrong total and sometimes comes back as 0 when there are values in the listed cells. Doesn't seem to be a erroneous formula, so what c...
Neither work. there are no text values and reformatting them didn't help. Your formula tweak with the two minus signs didn't work either
How do you know is that text or not? Re-formatting doesn't convert texts to numbers and the opposite, at least you shall re-enter values after applying another format.
To check you may enter in any empty cell =ISTEXT(A1) or so.
IF =SUM(--A1:A7) doesn't work, perhaps =SUMPRODUCT(--A1:A7) or =SUMPRODUCT(A1:A7*1)
- Its a financial spreadsheet that has worked for several years. Never had text in it, just numbers'