Thread: SUMIF within date range as a function of today()'s date
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 1
Default SUMIF within date range as a function of today()'s date

....or you could do the same with SUMPRODUCT....

=SUMPRODUCT(--(A3:A262<=TODAY()),--(A3:A262TODAY()-DAY(TODAY())),Q3:Q262)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568750

Reply With QuoteReply With Quote