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

Try...

=SUMIF(RangeX,TODAY()-30,RangeY)

I guess you probably want something like this...

=SUMIF(RangeX,""&TODAY()-30,RangeY)

Hope this helps!

In article ,
"SUMIF Help" <SUMIF wrote:

How do I enter Today()-30 as a criteria in a sumif function?