How do I enter Today()-30 as a criteria in a sumif function?
C Chris Lavender Dec 9, 2005 #2 SUMIF Help said: How do I enter Today()-30 as a criteria in a sumif function? Click to expand... Use a concatenation, eg =SUMIF(E10:E39,">"&TODAY()-30,F10:F39) HTH Best rgds Chris Lav
SUMIF Help said: How do I enter Today()-30 as a criteria in a sumif function? Click to expand... Use a concatenation, eg =SUMIF(E10:E39,">"&TODAY()-30,F10:F39) HTH Best rgds Chris Lav
D Domenic Dec 9, 2005 #3 Try... =SUMIF(RangeX,TODAY()-30,RangeY) I guess you probably want something like this... =SUMIF(RangeX,">"&TODAY()-30,RangeY) Hope this helps!
Try... =SUMIF(RangeX,TODAY()-30,RangeY) I guess you probably want something like this... =SUMIF(RangeX,">"&TODAY()-30,RangeY) Hope this helps!
