Please Help!!!

[PRIMA]

Hi to All,

I have a table shown below, I want to have a formula under the Planned Column C1. The condition is, If I change the Column C1, then in Column B2 gives me the sum of D3 up to the date of C1 only.

Can anybody help me please. Thanks!

[TABLE="width: 576"]
<tbody>[TR]
[TD="class: xl66, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]A
[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]B
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]C
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]D
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]E
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]F
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]G
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]H
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]I
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]J
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]K
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]1
[/TD]
[TD="class: xl68, bgcolor: transparent"]Cut-Off
[/TD]
[TD="class: xl68, bgcolor: transparent"]Planned
[/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"]15-Jul-14
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]Date
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]09-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]10-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]11-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]12-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]13-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]14-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]15-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]16-Jul-14
[/TD]
[TD="class: xl71, width: 64, bgcolor: transparent, align: right"]17-Jul-14
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]GF
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]125.14
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]125.14
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]125.14
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]125.14
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]356.48
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]356.48
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]356.48
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]356.48
[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]231.33
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4
[/TD]
[TD="class: xl68, bgcolor: transparent"]FF
[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"]31.29
[/TD]
[TD="class: xl73, bgcolor: transparent"]31.29
[/TD]
[TD="class: xl73, bgcolor: transparent"]31.29
[/TD]
[TD="class: xl73, bgcolor: transparent"]31.29
[/TD]
[TD="class: xl73, bgcolor: transparent"]89.12
[/TD]
[TD="class: xl73, bgcolor: transparent"]89.12
[/TD]
[TD="class: xl73, bgcolor: transparent"]89.12
[/TD]
[TD="class: xl73, bgcolor: transparent"]89.12
[/TD]
[TD="class: xl73, bgcolor: transparent"]57.83
[/TD]
[/TR]
</tbody>[/TABLE]

 

[ghrain22]

*Edit

=SUMIF(C2:K2,"<" & $C$1,C3:K3)

 

[PRIMA]

Thank you for the quick reply ghrain, however, the result is the sum of coulmn C to K, I want only up to column I, because C1 column is only up to 15-Jul-14. Thank again

 

[PRIMA]

Thank you so much ghrain22, it works well, I have added 1 after $C$1 as shown, =SUMIF($C$2:$K$2,"<" & $C$1+1,$C3:$K3) thanks again.

 

[ghrain22]

You're welcome