Thread: Sumif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Lavender
 
Posts: n/a
Default Sumif

"SUMIF Help" <SUMIF wrote in message
...
How do I enter Today()-30 as a criteria in a sumif function?

Use a concatenation, eg

=SUMIF(E10:E39,""&TODAY()-30,F10:F39)

HTH
Best rgds
Chris Lav


Reply With QuoteReply With Quote