How to assign (lock?) a formula to a cell?

[alis748]

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

 

[awoohaw]

Do you just want to display a blank cell? If so, try:

=IF(MIN(1*(H6:H65=""))<>0,"",SUM(H6:H65))

(this requires that all cells H6:H65 are blank. If any are populated then you will get sum.)

 

[alis748]

Yes! That's exactly what I wanted, thank you!

 

[awoohaw]

Yes! That's exactly what I wanted, thank you!

My pleasure, happy to help. I'm glad you found a solution in the forum.