Counting Data Which Doesn't Exist..

have you tried COUNTA? I believe COUNTA counts non blank cells only.

If you are using the COUNT function to assume a range of cells to be copied and pasted, then COUNTA may not be enough. COUNTA will count the number of cells that are not empty. Let's say its 17 used cells in a range of 20. So 3 cells are empty. If you use COUNTA to copy and paste your data, then you will only copy 17 adjacent cells, and that may include the blank ones. I recommend either adding a text filter to only show rows with data entered into your specified range, or using VBA to move the data by only selecting the cells that have contents. Does that make sense?

Yes, sounds like you have something hidden still in the cells because I just tried it again and it worked for me, didn't count blanks and did count non-blanks.

COUNTA does not count blank cells. But, if you used to have data in the cells before, they may still be considered "used". Try clearing the contents of those blanks cells that you are somehow counting, and then immediately save your file right after. Then, try again.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

If it happens again, try doing what you just did and then saving the file right afterwards.