excel_novice01
New Member
- Joined
- Jan 15, 2014
- Messages
- 3
I have a data set that has sums for various groups within the same column, so row 1-10 will have data and row 11 will have a sum for the above numbers. Then I will have rows 12-15 with numbers and a sum formula for the data in rows 12-15, etc etc. Is there a formula that I can use to only sum the cells that have the sum formulas?
Also, the sum formulas are 'subtotal' formulas, I don't know if this will make a difference instead of using the 'sum' formula.
Also, the sum formulas are 'subtotal' formulas, I don't know if this will make a difference instead of using the 'sum' formula.