Syntax . Value1: The item that you want to look up.It is required. Value2: Additional items in the cell that you want to count. it is Optional. How to use the COUNTA function in Excel ...

As at the time of writing (May 2025), although the COUNTA function is available on most versions of Microsoft Excel, only those using a version of Microsoft Excel released in 2021 or later ...

In simple words, the COUNTA function counts all the cells that are not empty in the selected range. To show you the method, I have created a sample data in Excel that you can see in the above ...

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) ... 8. =COUNT & =COUNTA. These simple functions count the total number of digits or text in a column of data.

How to manually sum in Excel. 1. Click the cell you want the sum to appear in and click "=." 2. Type a number or click a cell that has a value. 3. Type "+." ...