exclude highlighted numbers from calculations?

M

MarkBradUK

Is it possible to calculate the sum of row of figures, while excluding cell that have been colour high-lighted from the calculation?
 
D

DDM

MarkBrad, the short answer is Yes: Use the built-in SUM function to sum all
the cells, use a custom function to sum cells of a certain color, then
subtract the one from the other.

For a custom function that sums the values of cells with specific colors,
see this page: http://www.cpearson.com/excel/colors.htm.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


MarkBradUK said:
Is it possible to calculate the sum of row of figures, while excluding
Click to expand...
cell that have been colour high-lighted from the calculation?
 
Top