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 (82 downloads)

See more formula Challenges here

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

    This is my array formula (entered with Ctrl+Shift+Enter):
    =SUM(–(MMULT(–(D$6:F$35=H6),
    TRANSPOSE(COLUMN(D$5:F$5)^0))>0))
    The non-array version of the foregoing formula, which requires hard-coding of the array constant, would be:
    =SUM(–(MMULT(–(D$6:F$35=H6),
    {1;1;1})>0))

    Reply

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 *