Summing until the next cell that is not empty

[Natit]

Hello,
I'm looking for the formula that will sum the cells in column C while column A is empty (or till the next cell in column A that ha value)
In the attached I want the cell C2 to sum the data from c3-c6, cell C7 the sum of C8-c13, cell C14 the sum of C15-C22, and so on/
TIA
Nati

 

[Snakehips]

@Natit Does something like below help?
It may or may not be practical for you to have a formula in C ?

Book1
	A	B	C	D	E
1
2	Data1			21
3			11
4			1
5			7
6			2
7	Data2			66
8			16
9			6
10			12
11			7
12			12
13			13
14	Data3			166
15			29
16			9
17			21
18			11
19			21
20			23
21			-3
22			55
23	End
24
25
Sheet1

Cell Formulas
Range	Formula
D2:D25	D2	=IFERROR(IF(A2="","",SUM(OFFSET(C3,,,MATCH("*",A3:A99,0),1))),"")

 

[Fluff]

Another option

++Fluff.xlsm
	A	B	C	D
1
2	Data1			21
3			11
4			1
5			7
6			2
7	Data2			66
8			16
9			6
10			12
11			7
12			12
13			13
14	Data3			166
15			29
16			9
17			21
18			11
19			21
20			23
21			-3
22			55
23	End
Data

Cell Formulas
Range	Formula
D2:D23	D2	=IF(A2="","",IFNA(SUM(C2:INDEX(C3:C99,MATCH("*",A3:A99,0))),""))

 

[Natit]

HI,
Both worked perfect.
Now I have to implement it on the real data
Thanks a lot
Nati

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Natit]

Well guys, I was optimistic, but..
Maybe I didn't explain myself clear, but the formula is suppose to be in column C and to sum the rows beneath until the row where the cell in column A is not empty but not to include it.
In both formulas it sum also the next sum.
So, the formula in cell C14 gives me 166 (the right amount) but the formula in cell C7 gives me 232 (16+6+12+7+12+13+166) instead of 66. Also the formula in cell C2
gives me 253 (11+1+7+2+232) instead of 21.
I hope I made myself clear.
Thanks to you all that help with your answers.
Nati

 

[Fluff]

If you want the formula in col C, then you will either need to add it manually to each blank cell, in which case you can simply specify the range to sum, or you will need a macro to do it.