• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

Google Spread sheet count if not null

do you know how to set formula;
if the cell doesn't have any value, i want to count.
0
Hiroyuki Tamura
Asked:
Hiroyuki Tamura
1 Solution
 
barry houdiniCommented:
Perhaps you can use COUNTBLANK for example

=COUNTBLANK(A1:A100)

or for the opposite, counting cells which are populated

=COUNTA(A1:A100)

regards, barry

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now