Forum Discussion
The Sum function: adding two sums together
I want to add two separate sums found in the same data range. For instance, the sum of g14:g28 and the sum of g30:g43. I keep getting error messages and I can't figure out what Excel wants. This can'...
pbmarrow I ran into this same problem today. After reading the "helpful tips" below, I almost gave up. The sheet I was working with had been formatted by someone else and I was actually using the correct formula. Format the final SUM cell to General or Currency etc.!! The SUM of two SUMS will appear correctly. Here is my formula =SUM(D2:D14, D28:D30) Good Luck!