AUTOSUM FORMULA

[Guest]

Hi,
I need your help for the following. I have huge data and would like to enter
a formula in column D something like
e.g. in D3=IF (AND(ISBLANK(C3),N(C2)), AUTOSUM (C2),â€â€)
but the autosum base on range 1 row and 1 column above without any spaces in
between
e.g in D8= AUTOSUM (C5:C7) in D14=AUTOSUM (C13:C10) and so on…
Is there any way to do this in excel?

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


Thank you in advance for your help.

Hidaya

 

[Guest]

Hi
in D2 enter the following formula
=IF(B2<>"","",SUM(OFFSET(C2,0,0,-(ROW(B2)-LOOKUP(2,1/(LEFT($B$1:$B1,3)="No:"),ROW($B$1:$B1))+1))))

and copy this formula down

 

[Guest]

thank you frank, it works : )