[users] =Sum not returning correct value?
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 -- Ted Trobaugh Dolce Music and Audio www.dolcemusic.com sum error.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] =Sum not returning correct value?
Ted Trobaugh 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 Ted: The situation is that you have a number of rows that are hidden. When those rows are revealed, then the sum, manually calculated, is in fact 11, not 9. So the formula is giving the correct answer of 11 as the sum of Y2:Y93. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] =Sum not returning correct value?
Ted Trobaugh - ftroba...@gmail.com 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: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] =Sum not returning correct value?
Oh... a-hem... Ya, I knew that. How could I not know that? You thought I didn't know that? Ha ha I was just testing you. Ya. That's what it was. I was TESTING you. [?] Boy, do I feel like a dolt. Thanks. Ted On Sun, Aug 15, 2010 at 11:23 AM, Richard Detwiler wrote: > Ted Trobaugh 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 >> >> > Ted: > > The situation is that you have a number of rows that are hidden. When those > rows are revealed, then the sum, manually calculated, is in fact 11, not 9. > So the formula is giving the correct answer of 11 as the sum of Y2:Y93. > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > > -- Ted Trobaugh Dolce Music and Audio www.dolcemusic.com 413-549-5468