Hi, I'm trying to use a double IF condition but I do not know how.
Basically there are two columns I need to check. One contains date, and the other contains a type of food.
I want to sum up the amount of a certain type of food that have the date greater than Jan. 1, 2011.
What i was thinking of was
IF A1:A10 date > Jan. 1, 2011 COUNTIF B1:B10=Donuts
Please show me the correct way to do this!![]()
Bookmarks