Counting cells...

S

Snowmonster

New Member
Joined
Aug 25, 2011
Messages
43
Hi all...

Just tried putting the formula in to count blank cells 'COUNTA', but the cells have drop downs in, which are set to blank, and also have conditional formatting in to shade if blank, and the sum of the count comes to 0, when it should be 26, where am I going wrong?

Snowmonster :confused:
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Snowmonster said:
Hi all...

Just tried putting the formula in to count blank cells 'COUNTA', but the cells have drop downs in, which are set to blank, and also have conditional formatting in to shade if blank, and the sum of the count comes to 0, when it should be 26, where am I going wrong?

Snowmonster :confused:
Click to expand...
Try this...

=COUNTBLANK(A1:A26)

Adjust the range to suit

That will count both empty cells and cells the contain formula blanks "".
 
Upvote 0
Hi...

I tried something...

If you right click, and select 'Clear Contents' then it counts it, so it must be something to do with the actions of the drop down box...

Snowmonster
 
Upvote 0
Snowmonster said:
Hi...

I tried something...

If you right click, and select 'Clear Contents' then it counts it, so it must be something to do with the actions of the drop down box...

Snowmonster
Click to expand...
That means there's some kind of "invisible" entry in the cells like maybe a space character.

What result do you get with this formula:

=SUMPRODUCT(--(LEN(A1:A26)=0))
 
Upvote 0
Snowmonster said:
Hi...

Sorry, nope, that didn't work either...

Snowmonster...
Click to expand...
We're using that formula to troubleshoot the problem.

The result you get will let us know if a certain condition exists. If you don't tell us the actual result of the formula then we don't know if it worked or not.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
MsgBox CountIf
Replies
2
Views
65
julhs
J
D
  • Solved
Counting Consecutive Blanks
Replies
9
Views
700
felixstraube
F
T
  • Solved
Search for & Count Blank Cells of a certain color based on Y/N dropdown menus
2 3
Replies
21
Views
788
myall_blues
myall_blues
edge37
  • Solved
Autonumbering formula that ignores empty cells containing formulas and consider them blank
2
Replies
16
Views
314
Fluff
Fluff
R
  • Question Question
Linked dynamic named ranges - unexpected results.
Replies
2
Views
199
Ramses505
R

Forum statistics

Threads
1,224,609
Messages
6,179,875
Members
452,949
Latest member
Dupuhini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top