Solved

Google Spread sheet count if not null

Posted on 2011-03-23
1
444 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 125 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Stuck in voice control mode on your Amazon Firestick?  Here is how to turn it off!!!
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial demonstrates how to quickly find related content for YourTango's posts using MozBar Chrome extension.

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now