← 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:
- To count “Paid” in column C:
=COUNTIF(C2:C40,"Paid"). - To count marks over 60 in column B:
=COUNTIF(B2:B40,">60"). - 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.
