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!

	A	B	C	D	E	F	G	H	I	J	K
1	Cut-Off	Planned	15-Jul-14
2	Date		09-Jul-14	10-Jul-14	11-Jul-14	12-Jul-14	13-Jul-14	14-Jul-14	15-Jul-14	16-Jul-14	17-Jul-14
3	GF		125.14	125.14	125.14	125.14	356.48	356.48	356.48	356.48	231.33
4	FF		31.29	31.29	31.29	31.29	89.12	89.12	89.12	89.12	57.83

<tbody>
</tbody>

 

[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