Count Blank Formula

Marilen.Navarro103391

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

Genevieve P.

Hi @Marilen.Navarro103391

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

Razetto

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

Marilen.Navarro103391

@Razetto nothing happens, my cell is blank too.

Matt Johnson

Hi @Marilen.Navarro103391

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

Marilen.Navarro103391

@ Matt Johnson -

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

Genevieve P.

Hi @Marilen.Navarro103391

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

Marilen.Navarro103391

@Genevieve P. Thank you. It works !!!