Excel Formula Challenge #6 – Get Student Count

Here is another query which came to our Excel VBA WhatsApp Group yesterday. Have a look at the screenshot below. Left table is the data table, Right table is the Result we need by excel formulas. Teacher 1 shows 15 in output, You can count the yellow cells row to get the idea to build your logic.

Download Sample Data here

Formula Challange #6 (214 downloads)

See more formula Challenges here

8 replies
  1. Robert H. Gascon
    Robert H. Gascon says:

    This is my array formula (entered with Ctrl+Shift+Enter):
    The non-array version of the foregoing formula, which requires hard-coding of the array constant, would be:


Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *