Kiến thức

countblank function not working!


Bạn đang xem: countblank function not working!


Board Regular

Dec 3, 2015

  • Oct 7, 2016

  • #1

I am trying to use the countblank function to count all the blanks in a certain column.
I know there are blanks in that column because I can see them. When I do = countblank(e1:e9097) , I get a value of 0 (meaning there are no blanks in the column), which is not true.

When I try isblank(e233) which I can see as a blank cell, this returns false, which is also a wrong answer since I can see that this cell is a blank cell.

I appreciate any help. Thank you.


Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Back to top button