Thread
:
Sumif
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Domenic
Posts: n/a
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?
Reply With Quote