### 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. Nima says:

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

Reply
• IT Chat says:

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

Reply
2. Ankit says:

Want to be added

Reply
• IT Chat says:

Do you want get added on our WhatsApp Group?

Reply
3. 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
• IT Chat says:

Awesome, It is exactly how i did it.

Reply
• Shabbir says:

Not Working

Reply
• Shabbir says:

{=SUM((LEN(D\$6:F\$35)-LEN(SUBSTITUTE(D\$6:F\$35, H6,””)))/LEN(H6))}
this is exactly get right answer

Reply

### Leave a Reply

Want to join the discussion?
Feel free to contribute!