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
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

@Genevieve P. Thank you. It works !!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!