Hi excel experts!
I have H66 here that is SUM=(H6:H65). I don't have anything in H6:H65 right now, it's all blank. Is there anyway to assign the SUM=(H6:H65) formula to H66 so that I can delete H66 without deleting the formula? For example, I deleted F66 and the formula got deleted too. I tried googling "locking cell" and it all came back with solutions for locking the formula with a password so the formula cannot be edited - that is not what I want.
I would like all the cells be empty and not filled with $0.00 and only do I fill the table will the cells populate with the SUM value. Is there a way to do that? Thanks!
Alis
I have H66 here that is SUM=(H6:H65). I don't have anything in H6:H65 right now, it's all blank. Is there anyway to assign the SUM=(H6:H65) formula to H66 so that I can delete H66 without deleting the formula? For example, I deleted F66 and the formula got deleted too. I tried googling "locking cell" and it all came back with solutions for locking the formula with a password so the formula cannot be edited - that is not what I want.
I would like all the cells be empty and not filled with $0.00 and only do I fill the table will the cells populate with the SUM value. Is there a way to do that? Thanks!
Alis