Count of a Data Cell?

Ask the Community
1

image
image1478×404 24.9 KB

How do I accurately get the number of objects in a Data cell into another cell?
For example here, COUNT(B4) gives me 96, but upon inspecting the data I can see there’s 199 objects in the data array.

(The count is displayed in the bottom right, and the formula for C4 is COUNT(B4)

2

Hi @bhargavaman !

COUNT will only count that objects that are numbers.
COUNTA will count all non-empty objects.

Alternatively, you can also use =PARSE(B4,"length()").

Hope this helps.

1 Like
3

This did the trick! I already had some filters in my PARSE function for the data, so I ended up wrapping it in another PARSE like so:
PARSE(PARSE('data', 'filter'),'length()')

Thanks a ton mate :muscle: