COUNTA

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

4D View Pro Reference
- 4D View Pro Formulas
- - Operators and values
  - Cell references
  - Converting 4D View plug-in formulas
  - ABS
  - ACOS
  - AND
  - ASIN
  - ATAN
  - AVERAGE
  - COLUMNLETTER
  - COS
  - COUNTA
  - EXP
  - FALSE
  - FINDCELL
  - FV
  - IF
  - INDIRECT
  - ISBLANK
  - LEN
  - LN
  - LOOKUP
  - MAX
  - MID
  - MIN
  - NOT
  - NOW
  - NPER
  - OR
  - PI
  - PMT
  - PV
  - RAND
  - RATE
  - ROUND
  - ROW
  - RUNTIME_CURRENT_TIME
  - RUNTIME_DATE
  - RUNTIME_STRING
  - RUNTIME_TIME
  - RUNTIME_VIEW_STRING
  - SIN
  - SQRT
  - STDEV.P
  - SUBSTITUTE
  - SUM
  - TAN
  - TEXT
  - TODAY
  - TRUE
  - TYPE
  - VAR.P

Home

4D v19

4D View Pro Reference

4D View Pro Formulas

COUNTA


COUNTA ( value {, value2 , ... , valueN} )

Parameter	Type	Description
value	Real, Array	Cells or cell range to be counted

Description

The COUNTA function counts the number of cells specified in value that are not empty (i.e. cells that contain numbers, text, or logical values). It accepts cell references and returns numeric data.

In value, you can pass up to 255 separate cells or a single array of values.

Example

COUNTA(B2,D2,E4,E5,E6)

COUNTA(A1:G5)

PROPERTIES

Product: 4D
Theme: 4D View Pro Formulas

PAGE CONTENTS

Description

Example

HISTORY

ARTICLE USAGE

4D View Pro Reference ( 4D v19)

Add a comment