Count range of cells whether they are blank or have text

JennS_

I am trying to count a few things in this sheet to track % of the Cabin completion. I want the total # of cells in a row that are either blank OR have text in them so that I know when all the cells in that row have been completed. I have tried multiple COUNTIF scenarios and its not working.

completed.

Amber Eakin

Hi @JennS - I have an idea! Let me know if this helps!

=COUNTIF({RANGE}, OR(@cell = "", @cell <> ""))

Amber Eakin

Hi @JennS - I have an idea! Let me know if this helps!

=COUNTIF({RANGE}, OR(@cell = "", @cell <> ""))

JennS_

@Amber Eakin It worked! Thank you so much for your quick help!

JennS_

@Duncan Wasp

Marilen.Navarro103391

@Amber Eakin

how about if i want to count the "Blank" per month

=COUNTIFS({Battery CE Leads Range 1}, "Unqualified", {Battery CE Leads Range 2}, OR(@cell = "", {Battery CE Leads Range 3}, AND(IFERROR(MONTH(@cell), 0), Apr$1, IFERROR(YEAR(@cell), 0), =2023)))