### 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 (168 downloads)See more formula Challenges here

### Leave a Reply

Want to join the discussion?Feel free to contribute!

Hi.How Can Join Watsapp group? this is my phone number +989175236648 thanks

Please fill the form by on your mobile on this page http://www.itchat.in

Want to be added

Do you want get added on our WhatsApp Group?

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))

Awesome, It is exactly how i did it.

Not Working

{=SUM((LEN(D$6:F$35)-LEN(SUBSTITUTE(D$6:F$35, H6,””)))/LEN(H6))}

this is exactly get right answer