Get instant live expert help on count if not blank

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

i need to adjust a formula to not count blank cells
Solved by Z. J. in 13 mins
i am looking to get the count of vp where dollars not zero or blank
Solved by X. W. in 17 mins
Count number of days from line EJ to FE * if FE is blank, use current date , then count and mark red.
Solved by A. H. in 15 mins
I want to count how many rows have not had any action taken yet but are not yet Overdue. So my row G from cell G3 to G102 need to be blank and cell F3 to F102 need to be blank. I don't want it to count any rows that are blank (which naturally have the G and F columns blank. I want to count how many cells have F and G columns blank but still have text in column B which means that there is a task in that row. I've tried a few different formulas but they won't work.
Solved by I. H. in 29 mins
Hi, I need to count blank in "one specific column" but the range is not static. So every time I use countback equation, I have to manually change the range which is not helpful. Can I somehow link the countblank with some other entries in other columns? So that it can check if there are no entries in other columns, the equation count blank til last entry only
Solved by S. J. in 11 mins