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:

1
2
3
	6
4
5
6

<tbody>
</tbody>

15

 

[Aladin Akyurek]

Row\Col	A​	B​
1​	X	SUM
2​	1
3​	2
4​	3
5​		6
6​	4
7​	5
8​	6
9​		15
10​

In B2 enter and copy down:

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

 

[vsakzer]

Row\Col	A​	B​
1​	X	SUM
2​	1
3​	2
4​	3
5​		6
6​	4
7​	5
8​	6
9​		15
10​

<tbody>
</tbody>

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?

<colgroup><col><col><col span="7"><col><col span="4"><col><col><col span="2"></colgroup><tbody></tbody>