Need to sum only already summed cells down a column with constantly changing data

Hi. I am new to this forum, and I am completely lost when it comes to advanced formulas or VBA. I am trying to sum only certain cells in a column, and there will be cells that are added and deleted daily from the column. I'll try to explain:

In column V, cells V10:V714 all have numbers in them. Currently, there are 68 summed cells that sum the 1 or more cells above them. So there will be something like 5 values then a sum, 2 values then a sum, 10 values then a sum, etc. At the bottom, I want to sum ONLY the summed cells. These small groups that are summed are constantly changing, as in every day, one or more is deleted and every day, 1 or more new groups are added.

How can I create a formula in the very bottom cell that will sum only the summed cells and update with each change without summing any of the other cells with numeric values in them? I am thinking this is some sort of array thing or VBA deal, but I have never done any of that, and I really don't know much about how... I have seen some examples of similar things here and in other forums, but I can't quite get my head wrapped around my particular issue.

Thanks so much for any help! By the way, I am using some data that I need to keep private. If I need to attach my file, let me know, and I will manipulate the spreadsheet so that just the stuff I need help with is available.

Michael

UPDATE: I attached my file! I am trying to sum the summed cells in column V:Y (v15,v20,v25,v45, etc) down to Row 715. What changes is that I continually am adding new orders and deleting old ones, usually 15-20 changes a day, so it expands and contracts quite a bit.

It seems like it would be easier to replace all of your SUM functions with SUBTOTAL functions. Because SUBTOTAL functions ignore cells containing SUBTOTAL, you could use a final SUBTOTAL function to summarize the data.

Here's one way:
• Select Col_V
• CTRL+H...(shortcut for Home.Find&Select.Replace)
...Find what: =SUM(
...Replace with: =SUBTOTAL(9,
...Click: Replace All

• V1724: =SUBTOTAL(9,V10:V1723)

Is that something you can work with?

It seems like your project is edging into more structured Excel model territory.
Some suggestions:
• Remove all of the subtotals
• Inserted a column at the beginning to flag groups.
Example:
For the B121:C129 section, put a label in A121:A129....Group 20 (or whatever)
Assign a category for every other group.

• Whenever needed, have Excel automatically insert the subtotals, breaking on those groups.

• When it's time for more inputs...Have Excel automatically remove those subtotals.

OK...Here's an example, using your posted workbook as a base.
• I assigned a Group label to each row in Col_A
• I assigned generic column headings to give the next section more meaning.
• I removed all subtotal and blank rows

Now, here's what I want you to do:
• Open the attachement
• Select A10:Y1099
• Data.Subtotal
...At each change in: Group
...Use: Sum
...Add subtotal to: (check: Item_01 through Item_05)
...Click: OK

Excel will insert a subtotal row at each break in Group

Then you can work on formatting, etc.

If you ever want to remove the subtotals...
• Data.Subtotal...Click: Remove All

Is that something you can work with?

If every data cell is included in a subtotal, couldn't you just sum the entire range and divide by 2?

Glad I could help
...Please be sure to mark this thread as SOLVED...(Click the Thread Tools dropdown and select "Mark this thread as solved"