Is it possible to do nested countif functions?

Dear Dan

Thank you for attending Excel Advanced Course

Yes it is possible to have nested COUNTIF’s in your spreadsheet.

Please find the uploaded excel file were I have demonstrated this.

If you notice on Cell B1 the answer is 7 because the nested Function is on that cell is :

=COUNTIF(A3:A9,"Milk")+COUNTIF(B3:B9,"Bread")+COUNTIF(C3:C9,"Butter")

It is very simple.

Step 1: Click on the cell where you want the result. In our example it will be B2.
Step 2: Click on the fx button on the Formula Bar.
Step 3: Choose COUNTIF and click OK.
Step 4: Click on the Range box and select your first range. In our example this is A3:A9)
Step 5: Click on the Criteria box and type the criteria that the COUNTIF should meet. I type Milk.
Step 6: Click on the COUNTIF Button on the left hand side of the Formula bar (This appears normally where you'd expect to see the name box.)

As soon as you press that button what you’ll notice on the formula bar is that it will have + and a new COUNTIF Function.

The box will be empty for you to choose the next range and the criteria.

You can keep on doing that until you have chosen all your ranges and the criteria’s.

I hope this helps.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please as the question as a separate posting.


Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003

Attached files...

nested CountIF.xls