Google Docs Editor Help: COUNTIF

In Sheets, use the following formula to count how many times a specified value occurs within a given range on a sheet:

COUNTIF(range, criterion)

In practice this might look like:

COUNTIF(A1:A100, “yes”)