Count Blank Formula
Hello,
I was wondering if you can help me with my formula.
How do I count my Battery CE Leads Range 4 when my cells are "blank"
I need to count sum of Blanks each month. Thanks.
=COUNTIFS({Battery CE Leads Range 3}, "Unqualified", {Battery CE Leads Range 4}, $[STATUS UNQUALIFIED]@row, {Battery CE Leads Range 2}, AND(IFERROR(MONTH(@cell), 0) = Apr$1, IFERROR(YEAR(@cell), 0) = 2023))
Best Answer

To count blanks in a formula, you can count how many cells have: ""
=COUNTIF([Column]:[Column], "")
So in your case, instead of referencing a blank cell, try:
=COUNTIFS({Battery CE Leads Range 3}, "Unqualified", {Battery CE Leads Range 4}, "", {Battery CE Leads Range 2}, AND(IFERROR(MONTH(@cell), 0) = Apr$1, IFERROR(YEAR(@cell), 0) = 2023))
You will also need to add the month number, 4, in the cell Apr$1. This will get the formula to look for the month of 4, or April. If you leave that blank then your result will likely be 0.
Let us know if that helped!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers

@Marilen.Navarro103391 What happens if you enter the month in the yellow row? I wonder if the formula reads the month but it's comparing it with a blank cell.

@Razetto nothing happens, my cell is blank too.

To count blanks its best to compare the column against another column that's not blank. There's usually some blank rows at the bottom of the sheet that get picked up in the count if you only count blanks in (1) column.
As for your formula, there's a lot going on there that might not be needed. Here's an example of a formula that works for counting blanks. This returns the value of 1 in counting blanks in Column2.
I hope that helps.
Matt

@ Matt Johnson 
I'm doing a count of blanks on all months. I need a formula with months. Thanks.

To count blanks in a formula, you can count how many cells have: ""
=COUNTIF([Column]:[Column], "")
So in your case, instead of referencing a blank cell, try:
=COUNTIFS({Battery CE Leads Range 3}, "Unqualified", {Battery CE Leads Range 4}, "", {Battery CE Leads Range 2}, AND(IFERROR(MONTH(@cell), 0) = Apr$1, IFERROR(YEAR(@cell), 0) = 2023))
You will also need to add the month number, 4, in the cell Apr$1. This will get the formula to look for the month of 4, or April. If you leave that blank then your result will likely be 0.
Let us know if that helped!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
@Genevieve P. Thank you. It works !!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!