COUNTIF
If you want to calculate the occurrence of a particular item from many items, COUNTIF is very helpful in such cases.
The way I have written the formula =COUNTIF($B$2:$B$22,E2)
Please don't forget to lock the range and give comma.
My other videos
TRANSPOSE
• Transpose
IF FUNTION
• IF FUNCTION
CONCATENATE
• CONCATENATE
VLOOKUP
• Video