I have a simple spread sheet where I need to total up a number of cells that in turn have formulas. The small formulas are working fine, but when I total them up, I get a 0 on the spreadsheet, though the correct total shows up in the box while I am working on the formula. I've tried reformating the formula in different ways (taking out the word "sum", taking out the parentheses, using + instead of , between the various cells, etc.) but nothing makes it work. This is a formula I have used many times before, so I know it SHOULD work...but for some reason it isn't working now. Any ideas?
Here's the formula in question: Each of the cells contains a simple sum formula:
=SUM(H72,H65,H57,H50,H38,H31,H24,H16,H10)
Bookmarks