I have a very large budget spreadsheet that contains items and budget for these items.
example...
apples = $.50
bananas = $.75
oranges = $.25
beets = $.50
potatoes = $.75
carrots = $.25
Total budget = $3.00
Now I want to add in a header for these items and have the items below become subtasks.
Fruit = $1.50 (created a new autosum of just the subtasks)
apples = $.50
bananas = $.75
oranges = $.25
Vegetables = $1.50 (created a new autosum of just the subtasks)
beets = $.50
potatoes = $.75
carrots = $.25
The problem is my total sum at the bottom now becomes 6.00 because it autosums all of the cells. I could go back and just pick my new header totals, but again this is a very large budget and I want to make it as easy as possible. Do you know of a way I could run a macro or make this easy to total at the bottom. I just want to make sure that I am not counting any of my totals twice, if that makes sense.
example...
apples = $.50
bananas = $.75
oranges = $.25
beets = $.50
potatoes = $.75
carrots = $.25
Total budget = $3.00
Now I want to add in a header for these items and have the items below become subtasks.
Fruit = $1.50 (created a new autosum of just the subtasks)
apples = $.50
bananas = $.75
oranges = $.25
Vegetables = $1.50 (created a new autosum of just the subtasks)
beets = $.50
potatoes = $.75
carrots = $.25
The problem is my total sum at the bottom now becomes 6.00 because it autosums all of the cells. I could go back and just pick my new header totals, but again this is a very large budget and I want to make it as easy as possible. Do you know of a way I could run a macro or make this easy to total at the bottom. I just want to make sure that I am not counting any of my totals twice, if that makes sense.
