
THE SYNTAX OF COUNTIF ARE
=COUNTIF (RANGE, CRITERIA)
RANGE = SELECT THE WHOLE COLUMN RANGE FROM WHICH YOU WANT ANSWER
CRITERIA = SELECT THE PARTICULAR NAME FOR WHICH YOU ARE LOOKING FOR THE ANSWER FROM THAT SAME COLUMN SELECTED IN RANGE!!
DONT FORGET TO LIKE, SHARE AND COMMENTS!!