Highlight cell and it takes the figure within in away from another figure

Hi

I've got a spreadsheet with several rows and the numbers within those rows are totalled up at the bottom. Is there a way where i can highlight the cell within the spreadsheet and it takes it off the accumulative total at the bottom? or something similar to this effect? I just don't want to have to remove figures from this spreadsheet and highlighting will be a good way of seeing what has been done

thanks in advance

Hi

instead of Sum function use the UDF of Sumcolor function (code given below)
it will exclude highlited cells for summing

code:

HTML Code: