Cumbersome formula

[absolutelyprobable]

Hi,

Depending on what day it is (in cell A1), I want my total (in cell B2) to show the sum of figures in each row up to and including that day.

I've got a formula that does this but it's long which means I can't exstend this to cover two working weeks at a time.

Can anyone figure if there is/are function/s that will provide a neat solution?

Gareth

Book1.xls
	A	B	C	D	E	F	G	H
1	21/09/2006			18/09/2006	19/09/2006	20/09/2006	21/09/2006	22/09/2006
2		10		1	2	3	4	5
Sheet2

 

[Aladin Akyurek]

=SUM(D2:INDEX(D2:H2,MATCH(A1,D1:H1,1)))

 

[absolutelyprobable]

Wow

That's remarkably quick with your reply that does preciselly what I need

Fantastic! Thanks a lot Aladin - I seem to recollect you having helped me out before too. I appreciate the value your contribution adds to this forum.

Regards,
Gareth