Friday, June 23, 2017

COUNT function

COUNT function

Counts the number of arguments that contain numbers.

Syntax

COUNT(value1,value2,...)

Value1, value2, ...     are 1 to 30 arguments that can contain or refer to a variety of different types of data, but only numbers are counted.

Remarks

  • Arguments that are numbers, dates, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.

  • If you need to count logical values, text, or error values, use the COUNTA function.

Examples

Col1

Col2

Col3

Col4

Col5

Col6

Col7

Formula

Description (Result)

Sales

12/8/2008

19

22.24

TRUE

#DIV/0!

=COUNT([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7])

Counts the number of arguments that contain numbers in the list (3)

19

22.24

TRUE

#DIV/0!

=COUNT([Col4],[Col5],[Col6],[Col7])

Counts the number of arguments that contain numbers in the last 4 rows of the list (2)

Sales

2/8/2008

19

22.24

TRUE

#DIV/0!

COUNT([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7],2)

Counts the number of arguments that contain numbers in the list, and the value 2 (4)

No comments:

Post a Comment