When are they used:
COUNT :- To count the number of cells that contain numbers, use the COUNT function.
=COUNT(B39:B50)
COUNTIF :- To count cells based on one criteria (for example, less than 150), use the following COUNTIF function.
COUNTIFS :- To count cells based on multiple criteria (for example, R Madrid and greater than 30), use the following COUNTIFS function.