Question

This question was asked in Countif formula for counting duplicates
Akhil Sharma's image

I am not able to seen answer video. Please help me us to understand this better.