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!
You can use COUNTIFS formula in XL 2007
=COUNTIFS(A1:A1, ">1.1.2011", B1:B10, "Donuts")
Or you can put references:
=COUNTIFS(A1:A1, ">"&D1, B1:B10, D2)
So you can change Date (D1) and type (D2) .
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks