Count Functions


In Excel, the COUNT function is used to count the number of cells that contain numbers in a range. The basic syntax of the COUNT function is as follows:

=COUNT(value1, [value2], ...)

Here:

  • value1 is the first value or range that you want to count.
  • [value2] is an optional argument representing additional values or ranges that you want to include in the count.

For example:

=COUNT(A1:A8)

This formula will count the number of cells in the range A1:A8 that contain numeric values.



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
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

HYPER ERA PVT.LTD | TERMS & CONDITIONS