Invisible Cell?

Status
Not open for further replies.

default_name

Board Regular
Joined
May 16, 2018
Messages
170
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
I made a new topic for this because the problem appears to me to be separate from the original problem.
See the
original/reference post for additional details if needed.

I have a set of data.
I am using a COUNTIF function on a column.
Everything appeared to work fine. However, I ran a SUM routine to make sure that all the data was being captured.
I noticed that there are a few cells that are not being accounted for in the calculation.

I looked into some of the cells and discovered that A16 is not being counted in the equation.
Although the entire column A1:A500 is being counted, cell A16 (and a few others somewhere) is being skipped over.
Very odd. I have cleared contents, deleted the cell, inserted a blank cell, and checked formatting.

It is as if cell A16 is invisible in the COUNTIF function.

How do I go about finding this error and locating the rest of these 'ghost' cells?

Thanks in advance!
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Do you have any merged cells?
 
Upvote 0
Do you have any merged cells?
I really wish the OP had not started this new thread as it seems that one has to reference the other thread in order to know what the OP is talking about. In addition, the OP posted this question in the original thread and I gave the following response there...
I would be willing to bet that cell A16 has a space character at the end of the text. You can test this out with this formula...

=LEN(A16)

and see if the value returns is greater than 6.
Your thought about merged cells is also a good one though.
 
Last edited:
Upvote 0
Rick, thank you for your feedback. :)
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,562
Messages
6,114,326
Members
448,564
Latest member
ED38

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