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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Thank you. It works !!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!