How to sum groups of contiguous values automatically?

jaleahmad

New Member
Joined
May 15, 2008
Messages
9
Note: The number of values in the group can be anything between 1 and 1000. The list of values is preceded by the keyword "start"
Is there a formula to calculate the total?
Example of data:
start
1
2
1
1
2
3
1
2
Total=?

<tbody>
</tbody>
 
Last edited:

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

jaleahmad

New Member
Joined
May 15, 2008
Messages
9
correction: (actually the data has more than one group)
start
1
2
1
1
2
3
1
2
Total=?
start
1
2
11
1
2
Total=?
start
1
2
1
Total=?

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,099,376
Messages
5,468,248
Members
406,575
Latest member
Joe00

This Week's Hot Topics

Top