Solved Counting formula in Excel

April 23, 2012 at 23:55:05
Specs: Windows XP
Start Kitchen Bathroom
30/08/2011 YES NO
28/11/2011 NO YES
25/01/2012 YES

Hi, I'm abit stuck with this, I'll try and explain what I want. I need a formula in Excel that will count all the dates in the date column, if they have a YES in the Kitchen column, likewise I need to do the same with the Bathroom column. So the answers should be 2 for the kitchen and 1 for the bathroom. Hope this makes sense

See More: Counting formula in Excel

Report •

April 24, 2012 at 03:43:47
✔ Best Answer
What version of Excel do you have, if you have 2007 or 2010 there is a =COUNTIFS() function that should work for you.

for the Kitchen something like:


For the Bathroom



Report •
Related Solutions

Ask Question