How to Use Excel COUNTA Function in Office 365? – {with Examples}
Tags: excelcountafunctioni, excelfunctions
Published: 2020-09-03 10:48:12

---
title: How to Use Excel COUNTA Function in Office 365? – {with Examples}
published: true
date: 2020-09-03 07:13:05 UTC
tags: ExcelCOUNTAFunctioni,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-counta-function-in-office-365-with-examples/
---

## Excel COUNTA Function:

![COUNTA Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/COUNTA-Function.png)<figcaption id="caption-attachment-13218">COUNTA Function</figcaption>

In this article, we are going to see how to use the **Excel COUNTA Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **COUNTA Function – Explanation:**

- This function **counts the number of cells that are non-empty and returns the output in numbers**.
- It is just opposite to the [**COUNT Function in Excel**](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/).

## **Syntax:**

**=COUNTA(value1, [value2],…)**

### Argument Description:

**Value1 ** – The first argument, it may be an input value, or cell reference, or range.

**Value2 ** – It is an optional one. It is also the input value or reference or range of a cell.

### Note:

- COUNTA Function will count the cells that contain numbers, text, logical values, error values, and empty text(“”).
- You can also give input like **=COUNTA(“b”, 1, 2, 3, “”)**, and then it returns the **count values as 5**.

## **Examples:**

Here are the examples for your reference.

### Example 1:

- Refer to the below screenshot.
- You can see the input values in **Column A** , the output value is given in the **Cell C2**.
- This function counts only the non-empty cells from the given range of input.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-10.png)<figcaption id="caption-attachment-13215">Example 1</figcaption>

### Example 2:

- You can also give input like **=COUNTA(“b”, 1, 2, 3, “”)**, and then it returns the **count values as 5**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-8.png)<figcaption id="caption-attachment-13216">Example 2</figcaption>

### To Find Invisible Characters:

- This function will also count cells that look empty but it contains **invisible characters** or an **empty string (” “).**
- You can check which cells are blank in the input range. To find that, you have to **select a range of cells.**
- Then you need to press **CTRL + G** and It will open the “ **Go-To dialog box** “.
- Refer to the below image.

![Go-To dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Go-To-dialog-box.png)<figcaption id="caption-attachment-13222">Go-To dialog box</figcaption>

- Now, you can select the **Special Option** , and **choose the Blanks option**.

![Choose Blanks Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Blanks-Option.png)<figcaption id="caption-attachment-13223">Choose Blanks Option</figcaption>

- After clicking the OK button, it will show us the blank cells on the selected cell range.

![Blank cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_fXinUXmx7r.png)<figcaption id="caption-attachment-13249">Blank cells</figcaption>

## **Summary:**

In this article, you can learn how to use **Excel COUNTA Function in Office 365** with its syntax, explanation, and examples. Share your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**COUNT Function**](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/)
- [**COUNTBLANK Function**](https://geekexcel.com/how-to-use-excel-countblank-function-in-office-365/)

### Read Ahead:

- [How to Use Excel COT Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-cot-function-in-office-365-with-examples/)
- [How to Use Excel DEGREES Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-degrees-function-in-office-365-with-examples/)