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.