Microsoft Excel COUNTA Function Help
EMAGENIT Home page

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

 

COUNTA Function Examples

COUNTA Function Definition

Counts the number of occupied cells (non empty) in a range or entries in an array. COUNTA counts text, numbers, TRUE, FALSE, error values...etc. Use when you want to count everything.

COUNTA Function Syntax

=COUNTA(value1,[value2],...[Value30])

[] bracket means argument is optional which means you do not have to fill the slot.

COUNTA Function Argument Definitions

value1, value2, ...:   are 1 to 30 arguments that can contain or refer to a variety of different types of data. You can either type the information in as constants (i.e. numbers, text,...) or use cell references, ranges and names.

COUNTA Function Tips

  • COUNTA is used in statistical evaluations (how many people typed in cells in a range) and to determine the number of records (rows) in a table for example.
  • If you do not need to count TRUE, FALSE, text or error values, use the COUNT function to count numbers only.