subtotal by header?

[d_alten]

I have a sheet of data I need to subtotal. The issue is that the subtotal criteria is mixed in one column.
Example:

[TABLE="width: 500"]
<TBODY>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[/TR]
[TR]
[TD]Name 1
[/TD]
[TD][/TD]
[TD]35.00
[/TD]
[/TR]
[TR]
[TD]Shift Type
[/TD]
[TD]10.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shift Type
[/TD]
[TD]12.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shift Type
[/TD]
[TD]13.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 2
[/TD]
[TD][/TD]
[TD]20.00
[/TD]
[/TR]
[TR]
[TD]Shift Type
[/TD]
[TD]10.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shift Type
[/TD]
[TD]10.00
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

I need a formula that will subtotal column B based on when the NAME in column one changes, but column A has the name and shift type in the same column and it's not always 3 lines under the name it could be 6 for one person and 2 for another. So Column C is what I need the end result to be. I will take any direction or help you can give me.


Thanks

Diane

 

[Akashwani]

Hi Diane and welcome to MrExcel.

Does this work for you?....

Excel Workbook
	A	B	C	D
1	Data1	Data2	Result
2	Name 1		35
3	Shift Type	10
4	Shift Type	12
5	Shift Type	13
6	Name 2		20
7	Shift Type	10
8	Shift Type	10
9	Name 3		20
10	Shift Type	5
11	Shift Type	5
12	Shift Type	5
13	Shift Type	5
14	Name 4		20
15	Shift Type	10
16	Shift Type	10
17	Name5
18
Sheet1

The formula in C2 needs to be copied down.
I got the solution from here and changed it slightly....
SUM Column until blank cell is found

I hope that helps.

Good luck.

Ak