D
dayton
I need help with a SUMIF formula. I am trying to do a SUMIF with the range
being a column of dates. My criteria needs to be >= than a date I specify,
such as 01/01/03. When I add the >= to my formula I get zero for the sum.
I've been able to accomplish this before when I convert the date to numbers
but I want to avoid that this time.
SUMIF(Details!F2:F3156,DATE(2003,1,1),Details!D2
3156)
T.I.A.
being a column of dates. My criteria needs to be >= than a date I specify,
such as 01/01/03. When I add the >= to my formula I get zero for the sum.
I've been able to accomplish this before when I convert the date to numbers
but I want to avoid that this time.
SUMIF(Details!F2:F3156,DATE(2003,1,1),Details!D2
3156)T.I.A.