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?
