Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

COUNTA in Google Sheets™

How to use COUNTA in Google Sheets. This helpful formula works differently than COUNT. I will explain how.

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.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

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

%d