I am stuck with working out a formula for the following.
I need to sum H3:H64, but the some I was using showed the result as 100% if no data was in the cell and I want it to display blank if there is no value in either of the cells?
Where am I going wrong please.
The sum that displays 100% is this =100-SUM(H3:H64)/62 and I just nothing in it as I say if the value is blank
I tried this -
=SUM(H3:H64)/62(IF="0""")
But it was a no go
Bookmarks