My problem involves the criteria section of the SUMIF formula.
Firstly I have a list of dates in column A. In column B there is a corresponding list of numbers. In E1 I have =TODAY()-90. This cell is the criteria in the SUMIF formula; only problem is it doesn't work as I want it to work. If I insert it as =SUMIF(A:A,E1,B:B) the result obtained is corrrect, BUT I want the sum of the intervening days ie sum all the days greater than or equal to E1. I've tried >=E1, ">=E1", ">="E1, >="E1" but nothing works. I've tried formatting E1 as text, number, and date, still no dice.
Do I have to put quote marks around the quote marks to get it to work. I can't remember the steps to do that, I've seen it done somewhere.
The problem is driving me nuts, any advice greatly appreciated,