Count how often a value occurs - Microsoft Support
Use the COUNTIF function to count how many times a particular value appears in a range of cells. The COUNTIFS function is similar to the function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met.
more
|