Report

Formula [Solved]

Ask a question Jmccall2016 4Posts Wednesday June 14, 2017Registration date June 15, 2017 Last seen - Last answered on Jun 15, 2017 at 01:13 PM by x
I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the answer to show 2.

Can someone help me come up with a formula for this?

Jennifer
Helpful
+1
plus moins
Jennifer, Good morning.

Suppose your range of data:
A1:A100


Try to use:
=COUNTBLANK(A1:A100)

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
Leave a comment
Helpful
+0
plus moins
How can I add all the blanks if they are not in order? The data I am requesting is say A1, B1, D1, F1.. etc?
x- Jun 14, 2017 at 01:01 PM
Change the cell references to suite your requirement.

=SUMPRODUCT(COUNTBLANK(INDIRECT({"A1","B1","D1","F1"})))
Reply
Leave a comment
Helpful
+0
plus moins


If you can see the picture the formula is not adding up just the blanks. :(Thank you for your help with this.
x- Jun 14, 2017 at 10:18 PM
What is actually in those 'blank' cells?
A 'space' is not blank for example.
A result of a formula formatted as a blank is not blank.
Reply
Jmccall2016 4Posts Wednesday June 14, 2017Registration date June 15, 2017 Last seen - Jun 15, 2017 at 10:52 AM
There is nothing in the cells. They are infact blank.
Reply
x- Jun 15, 2017 at 01:13 PM
just noticed that the cells that are colored are in fact:
AR4 AP4 AN4 and AL4

unless you have hidden rows.
or that you really are intending to count row 1 in which case I have no idea.
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!