I have a range of cells that all contain if statements. These if statements are basically: if a reference cell is empty, leave the cell containing the reference formula blank, if reference cell is populated, populate the reference formula cell. An example is below that would be located in B1 as an example.
IF(A1="", "", A1)
I want a way to count the number of blank cells. Ordinarily I would use COUNTA, but that counts the number of empty cells, not the number of blank cells, and since all of the cells are populated with IF statements, it sees them as not empty, even though they are blank. Is there a function that counts the number of blank cells rather than COUNTA which counts the number of empty cells? I tried using COUNTIF, like I have below, but that looks for a condition that is true and in order to specify not true, it needs to be surrounded by quotes which messes up the concept of using quotes to represent a blank cell.
=COUNTIF(range, "<>""")
=COUNTIF(range, "<>")
– Scott Craner