Counta Function

Suppose you have a range of cells from A1 to A8, and you want to count the number of non-empty cells in that range.

Method 1: Using Range Reference

=COUNTA(A1:A8)

This formula will count the number of non-empty cells in the range A1 to A8.

Method 2: Using Multiple Range References

You can also use multiple range references as arguments:

=COUNTA(A1, A2, A3, A4, A5, A6, A7, A8)

This formula achieves the same result as the previous one, counting the number of non-empty cells in the specified range.

Related Topics

=> Introduction of Excel
=> User Interface
=> The Excel Interface: Application Window
=> The Excel Interface: The Workbook Window
=> Creating, Opening and Exporting Workbook and Compatibility mode
=> Understanding Cell, Cell content
=> Modify Row, Colums and Cell, Wraping text and Merging text
=> Excel Shortcut Key
=> Home Tab: Clipboard Font Formatting, Text Alignment
=> Home Tab: Number, Styles, Cell, Editing
=> Addition and the SUM Function
=> Subraction (Minus)
=> Multiply and PRODUCT Function in Excel
=> Divide or Division
=> Reminder in Excel
=> Max Function in Excel
=> Min Function in Excel
=> Average Functions
=> Count Functions
=> Counta Function

Follow Us