Sumif
 

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

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

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?

Sumif
 

Thanks to Chris and Domenic.. Happy Holidays..

"SUMIF Help" wrote:

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