Heya, I dont use Excel often, so this might seem like a silly question.
Is there a formula that can add a cell to a total, and if the cell gets deleted, the total cell still has the numbers added from the now empty cell.
Say if i want to a total for a football players yellow card during a season. I have cell A1, where i type in the number of cards he gets, and cell A2 adds them up. cell A2 still holds the number it has added up, but doesnt change if A1 is blank.
dont know if i explained it clearly
Thanks Tedd
Bookmarks