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!


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