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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excluding a paragraph tag from spelling check 0
Calculate elapsed time excluding specific timeframe 10
Making "Change Highlighting" feature darker 1
Subtoal excluding hidden columns 7
Calculate End Date (excluding weekends and holidays) 6
Sum if cell = grey 4
Standard Deviation and Averages based on criteria 2
Count Number of Unique Cells That Don't Have Certain Characters 0

Top