Summing with Spaces

[Mr. Barnes]

Hi,

If I have a column of numers like this:

3
4
4

3
2
1

3
2


Each group of numbers represents a different day seperated by a space.
In the adjacent column I want to do a running total of each group so I
have a running subtotal for each day, so it would look like this:

3 3
4 7
4 11

3 3
2 5
1 6

3 3
2 5

The formula looks complicated. Thanks for any help.

 

[Niek Otten]

Make sure the first line is empty
I assume that with "a space" you mean an empty row.
If your data is in Column A (starting in a2), put this formula in B2:

=IF(A2="",0,B1+A2)

And copy down as far as you need
You can format the zeros to show as spaces if that is important.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| If I have a column of numers like this:
|
| 3
| 4
| 4
|
| 3
| 2
| 1
|
| 3
| 2
|
|
| Each group of numbers represents a different day seperated by a space.
| In the adjacent column I want to do a running total of each group so I
| have a running subtotal for each day, so it would look like this:
|
| 3 3
| 4 7
| 4 11
|
| 3 3
| 2 5
| 1 6
|
| 3 3
| 2 5
|
| The formula looks complicated. Thanks for any help.

 

[Mr. Barnes]

Make sure the first line is empty
I assume that with "a space" you mean an empty row.
If your data is in Column A (starting in a2), put this formula in B2:

=IF(A2="",0,B1+A2)

And copy down as far as you need
You can format the zeros to show as spaces if that is important.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| If I have a column of numers like this:
|
| 3
| 4
| 4
|
| 3
| 2
| 1
|
| 3
| 2
|
|
| Each group of numbers represents a different day seperated by a space.
| In the adjacent column I want to do a running total of each group so I
| have a running subtotal for each day, so it would look like this:
|
| 3 3
| 4 7
| 4 11
|
| 3 3
| 2 5
| 1 6
|
| 3 3
| 2 5
|
| The formula looks complicated. Thanks for any help.

Hey, thanks for that. Would this work as well:

=IF(A2="","",B1+A2)