PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-COUNTA

INTRODUCTION

COUNTA FUNCTION in Excel counts the non-empty cells in a given range.

COUNTA FUNCTION doesn’t care about the data like COUNT FUNCTION counts the numbers, dates and text like numbers. COUNTA will take all the cells as filled, even if there is text, numbers, dates or any other format of data.

COUNTA FUNCTION is of utmost importance while working in VBA to find if the rows are empty or not and many other conditions.

 COUNTA counts the error values also as non empty.

PURPOSE OF COUNTA FUNCTION IN EXCEL

COUNTA FUNCTION returns the total number of non empty cells present in a given range.

PREREQUISITES TO LEARN COUNTA FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the STATISTICAL terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: COUNTA FUNCTION

The Syntax for the function is

=COUNTA( VALUES1, VALUES2….)

VALUES1 The range can be mentioned here in which the non empty cells are to be counted.

 

EXAMPLE:COUNTA FUNCTION IN EXCEL

DATA SAMPLE

Let us take a data  mixed with numbers, texts, error values and empty and check how COUNTA works.

DATA
 
1
3
5
HELLO
HOW 
ARE
 
YOU
DELHI
NEWYOUR
#DIV/0!
 
10

We’ll count the non empty cells in this complete range and find out the result using COUNTA function.

USING COUNTA FUNCTION IN EXCEL
USING COUNTA FUNCTION IN EXCEL

STEPS TO USE COUNTA FUNCTION-EXAMPLE

STEPS:

1. Place the cursor in the cell and type the following function

USE THE FOLLOWING FUNCTION

=COUNTA(E7:E17)

2. Press ENTER, the answer will appear as 10.

 

The answers can be checked manually. We find that all answers are correct.

 
 

generalized STEPS TO USE COUNTA function

HERE ARE THE STEPS TO USE COUNT FUNCTION
  • USE THE FUNCTION
  • =COUNTA(RANGE1, RANGE2….)  in the cell where we want the result.
  • Press ENTER and the result will appear.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: