Oops. sorry about that Max. I will slighly revise my formula in that case,

=SUMIF(Sheet1!A3:E3,"<="&A1,Sheet1!A4:E4)

Regards

Govind.

Max wrote:

"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
---