I need a formula that will sum a row up to a certain date. In the table
below the date is in a1 and the data is in a4:e4

I have been trying but what I have is not working
=SUM(OFFSET(Sheet1!$A$4,0,0,MATCH(A1,Sheet1!$A$3:$ E$3,0)))


A B C D E

01/26/05

1/24/2005 1/25/2005 1/26/2005 1/27/2005 1/28/2005
1 2 3 4 5


I will appreciate any help,

Thanks

Todd