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

See more formula Challenges here

8 replies
1. Nima says:

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

• IT Chat says:

2. Ankit says:

• IT Chat says:

Do you want get added on our WhatsApp Group?

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

• IT Chat says:

Awesome, It is exactly how i did it.

• Shabbir says:

Not Working

• 