M
Mo
Would anyone like to tell me how it would be possible to add only the cells
that are colored e.g. red through a range
Mo
that are colored e.g. red through a range
Mo
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
merjet
Would anyone like to tell me how it would be possible to
Function SumRed(Target As Range) As Integer
Dim c As Range
For Each c In Target
If c.Interior.ColorIndex = 3 Then SumRed = SumRed + 1
Next c
End Function
HTH,
Merjet
add only the cells that are colored e.g. red through a range
Function SumRed(Target As Range) As Integer
Dim c As Range
For Each c In Target
If c.Interior.ColorIndex = 3 Then SumRed = SumRed + 1
Next c
End Function
HTH,
Merjet
C
Chip Pearson
Mo,
You need to use a VBA procedure to do this. See the SumByColor function at
www.cpearson.com/excel/colors.htm .
You need to use a VBA procedure to do this. See the SumByColor function at
www.cpearson.com/excel/colors.htm .
M
merjet
If c.Interior.ColorIndex = 3 Then SumRed = SumRed + 1
That should have been:
If c.Interior.ColorIndex = 3 Then SumRed = SumRed + c
Merjet
That should have been:
If c.Interior.ColorIndex = 3 Then SumRed = SumRed + c
Merjet
M
Mo Childs
Thanks to Chip & merjet for the help