Autosum

[Hidaya]

Hi ,
I have the following data and would like to get the sum in column D for amt
in column C (based on no. 2 in column C) for e.g D3=sum(C2),D8=sum(C5:C7) and
so on…
Is there a way to do an autosum based on the cell 1 row & 1 column above it?
Thank you for your help.

A B C D
1 1 NO: 22076
2 2 G06 100
3 3
4 1 NO: 22077
5 2 G02 50
6 2 G04 130
7 2 G03 12
8 3
9 1 NO: 22078
10 2 G02 50
11 2 G04 130
12 2 G06 35
13 2 G03 34.5
14 3
15 1 NO: 22081
16 2 G02 70
17 2 G03 59

 

[Frank Kabel]

Hi
just to be sure what you want to sum:
- all rows above which conmtain the same number (e.g. 2) in column B
- But only up to the next chane. So for example don't sum all '2' in D8 but
only starting in row C5?

 

[Hidaya]

that's right.

Hi
just to be sure what you want to sum:
- all rows above which conmtain the same number (e.g. 2) in column B
- But only up to the next chane. So for example don't sum all '2' in D8 but
only starting in row C5?

 

[Hidaya]

Hi Frank,

I mean I want to sum up based in the range from the 1 row & 1 column above
till the 1st value from that range i.e in D8 =sum C5:C7, D14 = sum C10:13
etc...and it must be based on no. 2 in column B.