How do I add a column of numbers up to a blank row

[vsakzer]

I have to add data to a spreadsheet every day, and I leave a blank row between each day. I would to be able to add that column of numbers without changing the range manually.

See example:

[TABLE="width: 100"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
15

 

[Aladin Akyurek]

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][/tr]
[tr][td]

1​

[/td][td]X[/td][td]SUM[/td][/tr]
[tr][td]

2​

[/td][td] 1[/td][td] [/td][/tr]
[tr][td]

3​

[/td][td] 2[/td][td] [/td][/tr]
[tr][td]

4​

[/td][td] 3[/td][td] [/td][/tr]
[tr][td]

5​

[/td][td] [/td][td] 6[/td][/tr]
[tr][td]

6​

[/td][td] 4[/td][td] [/td][/tr]
[tr][td]

7​

[/td][td] 5[/td][td] [/td][/tr]
[tr][td]

8​

[/td][td] 6[/td][td] [/td][/tr]
[tr][td]

9​

[/td][td][/td][td] 15[/td][/tr]
[tr][td]

10​

[/td][td][/td][td][/td][/tr]
[/table]

In B2 enter and copy down:

=IF($A2="",SUM($A$2:A2)-SUM($B$1:B1),"")

 

[vsakzer]

[TABLE="class: grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]X[/TD]
[TD]SUM[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD] 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD] 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD] 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD][/TD]
[TD] 6[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD] 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD] 5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD] 6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD][/TD]
[TD] 15[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


In B2 enter and copy down:

=IF($A2="",SUM($A$2:A2)-SUM($B$1:B1),"")

That's cool!!! Never thought of that!!! Thanks

Now I have to add it into the formulas I have for averages and counts. How do I post part of the SS so you can see the formulas I am using?[TABLE="width: 1264"]
<colgroup><col><col><col span="7"><col><col span="4"><col><col><col span="2"></colgroup><tbody></tbody>[/TABLE]