Add cell "50+55+50+50" to give answer 205
maybe
=50+55+50+50
that'll leave the individual amounts visible to anybody who selects the
cell, but will still show the total in the cell itself
"shyboy2k" wrote:
I have a cell where I need to keep the amounts separate to show workings
out, but I need this to be then added up in a sum, is there a way to do this
as at present I have to manual work this out and enter in another cell toget
the answer and this leaves too much room for error.
|