Excel countif and countifs
Countif allows you to count either a text or numeric string to determine the number of occurrences. COUNTIFS allows youto count either text or numbers to determine the number of occurrences, allowing you to find numbers with a specific range, i.e. 100 - 200 in a data set range