User Profile
R0bperry904
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Excel continues to have SUM 0.00 even though all formula are correct
My =SUM continues to display 0.00 when adding multiple cells with function totals of their own. My column values each have cell D4 with formula =SUM(C4*M4) to get a total of two entered values for the row. This value calculates correctly. I have this formula continuing for an entire page down 287 rows. I want to get a grand total for all rows so I have a formula in D2 that reads =SUM(D4:D287). The formula result reads 0.00. Checking all formula and all read correct. None are text or anything other than a formula. I have even tried to do =D4+D5+D6+ ect and I get the same result. My formulas are correct as far as I can tell. I have set them to Accounting, Currency, and even Just Numbers and it does not change. When I open up the Formula Function Arguments it shows the correct results and total. Yet the D2 cell continues to show 0.00. I went back through it and did a =SUM but just selected the cells with values other than 0.00 and it finally totaled correctly. So something is taking the SUM of the column and only counting the 0.00 cells and not the value calculated cells and displaying that result. Either that or there is something in the formula that is doing it. But its a simple =SUM() formula. Any ideas would be helpful.Solved207KViews0likes15Comments
Recent Blog Articles
No content to show