"Govind" wrote:
=SUMIF($A$3:$E$3,A1,$A$4:$E$4)

Perhaps not, in this instance, Govind

I read it from the OP's line:
... will sum a row up to a certain date

that OP wants to sum from 24-Jan to 26-Jan*
*the date specified in A1 in the sheet where his formula lies
Think his formula is on another sheet, whilst the source data is in Sheet1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---