# Count Blank Formula

Options
edited 06/30/23

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

• Employee
Options

To count blanks in a formula, you can count how many cells have: ""

=COUNTIF([Column]:[Column], "")

=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

October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭✭
Options

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

• Options

@Razetto nothing happens, my cell is blank too.

• ✭✭✭✭✭✭
Options

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

Sevan Technology

Smartsheet Aligned Partner

• Options

@ Matt Johnson -

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

• Employee
Options

To count blanks in a formula, you can count how many cells have: ""

=COUNTIF([Column]:[Column], "")

=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

October 8 - 10, Seattle, WA | Register now

• Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!