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