I want to exclude the values of cells that are shaded in a summation, e.g. I
have SUM(A9: Z9) = 1000, but I do not want cells F9, M9 and Y9, so I
highlight them in, say, green, then manually amend the appropriate cell
calculation to deduct these values.

Can Excel account for highlighting in this way?