Skip to content

← Using a Computer, in Practice

Spreadsheets · 60 of 111

Count how many with COUNTIF

Expert guidance

Do this

In LibreOffice Calc, Google Sheets or Excel:

  1. To count “Paid” in column C: =COUNTIF(C2:C40,"Paid").
  2. To count marks over 60 in column B: =COUNTIF(B2:B40,">60").
  3. Press Enter.

Why this way

It’s right every time the list changes, whereas counting by eye isn’t. One catch: “Paid”, “paid ” with a space, and “Pd” aren’t all the same, so type your values the same way each time. Treasurer of a club? This is your friend. Expert guidance.

Do it today

List ten friends and the fruit each likes, then count one fruit. Three minutes.

Where these facts come from
  • COUNTIF, Google Docs Editors Help.

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do