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:

Column A	Column B	Column C
Name 1		35.00
Shift Type	10.00
Shift Type	12.00
Shift Type	13.00
Name 2		20.00
Shift Type	10.00
Shift Type	10.00

<TBODY>
</TBODY>

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