How do I conditionally sum a set of cells if I have them highlighted?

Hi David,

See Chip Pearson's conting and summing functions at:

http://www.cpearson.com/excel/colors.htm


---
Regards,
Norman



"David" wrote in message
...
How do I conditionally sum a set of cells if I have them highlighted?

http://www.cpearson.com/excel/colors.htm

--
Kind regards,

Niek Otten

"David" wrote in message
...
How do I conditionally sum a set of cells if I have them highlighted?

You will need a UDF, the following will sum every cell if it has ANY color
shading (will ignore only the cells with no shading). Then, to implement,
use the following in any cell on your spreadsheet =SumHighlighted(A1:D100)...
change reference to fit your data.

Function SumHighlighted(rng As Range)
For Each rng In rng
If Not (rng.Interior.ColorIndex = xlNone) Then
Sum = Sum + rng
End If
Next
SumHighlighted = Sum
End Function
--
Regards,
Dave


"David" wrote:

How do I conditionally sum a set of cells if I have them highlighted?