Google Docs Sheets Help: COUNTIFS

Use this formula in Google Sheets to calculate the number of times a value occurs within a specified range:

COUNTIFS(criteria_range_1, criterion_1, [criterion_range_2, criterion_2, …])

An example implementation is below:

COUNTIFS(A1:A100, “Staff”, B1:B100, “>10”)

In this case a row would only be counted if the value in the A column was “Staff” AND the value in the B column was greater than 10.