?
Solved

Google Spread sheet count if not null

Posted on 2011-03-23
1
Medium Priority
?
481 Views
Last Modified: 2012-05-11
do you know how to set formula;
if the cell doesn't have any value, i want to count.
0
Comment
Question by:Hiroyuki Tamura
1 Comment
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 35199059
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Getting a solution on Experts Exchange is pretty easy--if you are asking the right questions in the right way.  While you won't get answers like RTFM or STFW from EE, experts will shy away from questions that are not focused, are badly explained, o…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question