Count Blank Formula

Marilen.Navarro103391
Marilen.Navarro103391 ✭✭✭✭✭
edited 06/30/23 in Formulas and Functions


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

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!