G Guest Jun 24, 2004 #1 Is it possible to calculate the sum of row of figures, while excluding cell that have been colour high-lighted from the calculation?
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 Jun 24, 2004 #2 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?
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?
