Forum Discussion
ablackwell1205
Oct 31, 2023Copper Contributor
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?