Ted Trobaugh - [email protected] wrote:
Greetings,
I am using Ooo 3.2.1; Build 9502
OSX 10.6.4
There is a simple Sum formula that is not returning the value I think it
should be returning.
Why isn't the "Sum" formula in cell Y96 giving me the right value? It
should be adding all the numbers from Y2 to Y93. If I add the values by
hand, the answer is 9, but the formula "=Sum(Y2:Y93)" is returning 11.
All the cells in the range Y2 to Y93 contain formulas.
Any insights? Thanks for your time.
Ted
Hi Ted,
You have data in hidden rows; look down the left side; there are gaps in
the row numbers, with a heavier line, where rows are hidden. These are
still included in the sum, even though not displayed. Hidden cell Y39
contains 2, hence the difference between the value returned by the
formula and those you can see and add up by hand.
Mark.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
