How to Return a Blank Cell if Another Cell Contains a Value

Copper Contributor

Hi! So, I am trying to use the =COUNTA function to count the number of cells that contain value. The problem that I am running into is the cells I am referencing have a =IF code which returns "" if the value in another cell is 0. COUNTA acknowledges that "" is not a blank cell but is a value so it counts it. Is there a way around this?

1 Reply



You might use

=COUNTIF(range, ">= ")