View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default sumif based on date

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

Yes, perhaps a good alternative here, Govind <g
It's much shorter ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---