Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel 2003 SUMIF problem?
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,
5 Answers
- expletive_xomLv 71 decade agoFavorite Answer
gotta concatenate your signs together with a cell reference
=SUMIF(A:A,">="&E1,B:B)
">=E1" just turns E1 into text
- Andrew LLv 71 decade ago
OK this is a bit of a cheat using a helper column, but often simplicity is a virtue!
In C1 put
=IF(A1>=E1,B1,0)
Drag this down and total col C at the bottom.
- How do you think about the answers? You can sign in to vote the answer.
- Anonymous5 years ago
Your formula has been graciously truncated by Yahoo Answers. Try adding some random spaces to it to overcome this lovely irritation...
