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 if we had the following list of attendees of our Super Bowl party...

...if we wanted to figure out how many total friends were at the 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!