When are they used: COUNT :- To count the number of cells that contain numbers, use the COUNT function. 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 […]