Last Updated: February 25, 2016
· nathansmonk

Count entries based on a variable in a spreadsheet

If you need to count the number of entries that meet a certain criteria in a spread you simply need a "COUNTIF" formula like this:

=COUNTIF(A:A, "<60")

In plain English: COUNT the number of cells IF the value in the column A is LESS THAN 60.

You can even modify this formula to search for text based queries. This would look a little something like this:

=COUNTIF(B:B, "Smile")