Forum Discussion

ablackwell1205's avatar
ablackwell1205
Copper Contributor
Oct 31, 2023

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

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?

Resources