Would like to write an IF statement where it reads if any cells in a column are highlighted and gives the sum of those highlighted while ignoring the ones unhighlighted.

Is there any way to do this or an alternate method that would possibly work???

Thanks