Excel

Hello Calvin

Thank you for your question and welcome to the forum.

There are several ways to count items in Excel.

You can use COUNT or COUNTA functions:

=COUNT(cell range) or =COUNTA(cell range)

COUNT will tell you how many numbers (values) there are in the cell range in the brackets; COUNTA will tell you how many cells contain something (can be text or numbers).

So these can be used to answer 'how many' questions.

You can also use COUNT without entering a function - select the cell range and then right-click on your status bar at the bottom of the screen, and select Count to display how many numbers are in the range you selected.

COUNTIF will count specific instances of something within a cell range:

=COUNTIF(cell range, criteria).

For example, if I wanted to know how many times the number 1 appeared within the range B5:B20 I would enter:

=COUNTIF(B5:B20,1)

I hope this helps.
Amanda