How to Use COUNTA Function in Excel | Step-by-Step Tutorial & Quiz
Do you want to find out the number of cells with data in a range of an Excel worksheet? Use the COUNTA function. It counts the number of non-empty cells in a given range of the Excel worksheet.
Let's consider a scenario for which you want to use the Excel COUNTA function: Say you have a worksheet with two columns, Name Membership Fee. Assume there are three thousand entries in this worksheet. If you want to find out how many people have paid the membership fee, use the COUNTA function as one way to accomplish this task.
If a member has paid the fee, the relevant cell in the Membership Fee column will have an entry. Otherwise, the cell will be blank.
Say the COUNTA function returns 2700. It indicates 300 members are yet to pay their fees.
How to use the COUNTA function in Excel? Here are the steps:
1. Start Excel.
2. Open or create a worksheet with non-empty and empty-cells
3. Click on an empty cell, say C1.
4. Type "=cou" (without quotes).
5. Double-click the COUNTA function from the drop-down menu that appears. Excel inserts the COUNTA function in cell C1.
6. Specify the range in which you want to count non-empty cells: Click the first cell of the range, say A2.
7. Click and drag the corner point of A1 till the last cell of the range, say B8.
8. Press Enter. Excel counts the number of non-empty cells in the range A2 to B8 and displays the result in C1.
Now enter data in an empty cell(s) in the range A2 to B8. Excel will automatically update the result of the COUNTA function in C1.
If you know how to use the COUNTA function in Excel, you can find out the number of non-empty cells in a given range of an Excel worksheet.
--------------------------------------------------------------------------------------
PowerPoint Videos
You may be interested in these PowerPoint Courses:
Font size for PowerPoint Presentation
• Font Size for Powerpoint Presentation...
How to Improve PowerPoint Presentation
• How to Improve PowerPoint Presentatio...
PowerPoint Tips
• PowerPoint tips | How to Improve Powe...
--------------------------------------------------------------------------------------
MS Word Videos
You may be interested in these Word Courses:
How to Create a Drop Cap in MS Word
• What is Drop Cap in MS Word | How to ...