sum of cells above specific word

[hansamfotos]

related to https://www.mrexcel.com/forum/excel-...t-strings.html

In relation to the link above, how to do it if the data is vertical. Say

1
2
Total
1
2
3
4
5
Total
1
2
3
4
4
5
5
Total

That is on one column only and would like to get the sum of the numbers above "Total" on the row adjacent to "Total"

Thank you!

 

[mrshl9898]

I put the above in A2 down.

In B2 =IF(IF(A2="Total",ROW(A2)-1,B1)=0,0,IF(A2="Total",ROW(A2)-1,B1))
In C2 =IF(A2="Total",SUM(INDIRECT(ADDRESS(B1+2,1)&":"&ADDRESS(B2,1))),"")

 

[Peter_SSs]

Welcome to the MrExcel board!

Try this, copied down.

Excel Workbook
	A	B
1	Data	Total
2	1
3	2
4	Total	3
5	1
6	2
7	3
8	4
9	5
10	Total	15
11	1
12	2
13	3
14	4
15	4
16	5
17	5
18	Total	24
Sum for each total