Skip to content
Home » Google » COUNTA in Google Sheets™

COUNTA in Google Sheets™

What formula do I use the most in Google Sheets, it might be =COUNTA. Let me explain to you what COUNTA does and how it is different than =COUNT.

How to use COUNTA

=COUNT(range) will count how many numbers are in the selected range. Notice in the sample sheet that there are 48 numbers in the grid of numbers and words. However, of all the numbers and words, there are 133 cells with content. =COUNTA(range) counts both numbers and alphanumeric values in the cells.

In a cell type an equals sign and type COUNTA(
Then, highlight the range of cells that contain words and/or numbers.
Press Enter.

=COUNTA($D$3:$J$21)

In this example, I have used absolute cell referencing around the cell range. This absolutely guarantees I am counting the values between cells D3 and J21. I would have obtained the same results if I had used =COUNTA(D3:J21). However, since I copied the cell A3 using =COUNT( on the same range, by adding the dollar signs I guaranteed that both were comparing the same range.

Tip: Use F4 to automatically add the dollar signs for your absolute cell referencing.

Change Some of the Values

In the sample spreadsheet, change some of the words to numbers or vice versa. You can also delete some of the values entirely. This will allow you to see how =COUNT works differently than =COUNTA.

I almost always use =COUNTA(

Since =COUNTA also counts numbers it pretty much works all the time. I reserve =COUNT for when I have a mixture of numerical cell values and textual cell values but I only want to count the numbers. In other words, I never use COUNT.

How to Update Student Spreadsheets

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…

Google Docs Google Play App Store Install

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Navigate Google Forms Sections

If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections

BETTER – Print Google Form Quiz

Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…

Something Fun for the End of the Year

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.