COUNT | CSE 148 – Excel Exam 1

COUNT explained

Say you're watching the Super Bowl with your friends, and some of you decided to bet on the game.

Before the game, everyone's name was written on a whiteboard with how much of their money was on the line. If you decided you didn't want to gamble, your excuse was written next to your name instead of a dollar amount.

Out of this list, if we wanted to easily figure out how many people actually bet on the game, we could use a COUNT function!

COUNT returns the count of numbers in a given list of values/cells. It does not include blank spaces or text in the result.

Coding a COUNT

Let's transfer the whiteboard above onto an Excel spreadsheet:

Now, let's reference the COUNT template and apply it to our Excel sheet.

=COUNT(number1, [number2]...)

For our number1 and number2 we'll just click and drag our mouse over all the betting values on the spreadsheet in column B.

=COUNT(B2:B19)

Perfect! This shows us that out of all our friends, 13 of them decided to place money on the Super Bowl game.

COUNT vs. COUNTA

Sometimes, you may be asked to determine how many values exist in a list, including text. This is where COUNTA comes into play.

While COUNT only determines how many numbers are in a given range, COUNTA determines how many values (including text) are in a given range.

So, in our whiteboard case, if we wanted to figure out how many total friends were at the Super Bowl party, we could accomplish that with a COUNTA function like so!

=COUNTA(B2:B19)

We now know there are 18 friends at the Super Bowl party!

Practice problem

Given the following race results, determine how many of the participants actually finished the race. Any participants without an end time did not cross the finish line.

=COUNT(C2:C9)

5 participants finished the race!

Next, let's figure out how to round numbers with the ROUND function!

Excel Cram Kit (Exam 1)

Want to unlock content? Get your Excel Cram Kit (Exam 1) now!

ApplyPRACTICE EXCEL EXAM 1 (PREVIEW ONLY)
ToolsExcel Nerd Notes (Exam 1) (PREVIEW ONLY)
LessonYEAR, MONTH, DAY
LessonSUM & AutoSUM
LessonRelative vs. Absolute Cell References
LessonRANK
LessonCOUNT
LessonROUND
LessonWEEKDAY vs. WORKDAY (PREVIEW ONLY)
LessonVLOOKUP (PREVIEW ONLY)
LessonPMT (PREVIEW ONLY)
LessonIF (PREVIEW ONLY)
LessonPercent change (PREVIEW ONLY)
LessonExcel charts (PREVIEW ONLY)
LessonImporting text files (PREVIEW ONLY)

Excel Reviews (Exam 1)

"I bought this Cram Kit the night before my exam, and it helped me tremendously. It provides step-by-step explanations for all the units covered in class."

Matt Lamanna
Oct. 14, 2021

Rating: 5 out of 5.

Leave a Comment