Get instant live expert help on countblank function in excel

“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

Simple formula using isblank or countblank doesn't keep relative cell references when I copy the formula, but the formula works fine if I type it in manually. This is true regardless of whether the data being referenced is in a table or not. So strange! Help!
Solved by G. Q. in 13 mins
=INDEX(A1:A17,SMALL(IFERROR(ROW(INDIRECT("1:"&COUNT(A1:A17)+COUNTBLANK(A1:A17)))*IF(A1:A17="","",1),""),ROW(INDIRECT("1:"&COUNT(A1:A17))))) Can you help me explain in words what this formula is doing?
Solved by B. J. in 25 mins
In EXCEL 2016 HOUR Function in SQL fails with "Hour is not a recognized function
Solved by M. J. in 15 mins
Need help in excel formula - IF function
Solved by I. H. in 17 mins
Need help using countifs function in excel
Solved by O. Q. in 21 mins