Function Type:
Statistical
Description:
COUNTBLANK function in Excel or Google Sheets counts cells that are blank in a given range of cells specified. Literally just the empty / blank cells. Even a single space bar character or invisible texts (white font on white fill cell) on a cell well not be included in the count of COUNTBLANK.
In my head, Excel or GSheets is just COUNTing BLANKs.
It is very useful to me when checking if everything on a range is blank to see if there are hidden space bar and invisible texts that are causing errors or incorrect computation on my formulas/functions.
This is because most of the time I hide texts using white font color when the information is not relevant for the audience, but useful for computations.
Same goes with errors where I usually use IFERROR then change the error to a blank or space.
Function Structure:
=COUNTBLANK ( range )
Argument Breakdown:
range - The range in which to count blank cells.
Error Handling
Possible Error
#NAME?
#NAME? error show up when Excel or Gsheets can't recognize the function we use
In this case, it was a misspelling of the word COUNTBLANK -> CUONTBLANK.
Solution:
Ensure that you're using the correct function name "COUNTBLANK" without any typos or additional characters.
Another possible error: This can also come up from typing the wrong syntax.
Solution: It's usually best to select the cell or range of cells when using COUNT function to avoid mistakes.
Still need help with Excel and Google Sheets?
Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
This post is designated as a reviewer for Excel trainings I conduct.
Feel free to share with anyone. 😉
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
Earn passive income by sharing your internet bandwidth with Honeygain
If you are looking for a charity to donate to, please consider Food for Hungry Minds.