Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum all Cells with Interior Color Index not equal to 0
I need to sum cells in Range("F5:F" & LastRow) that have a Interior Color
Index < 0. Is there an easy way to do this? Thanks is Advance, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum all Cells with Interior Color Index not equal to 0
One way:
First, 0 is not a valid value for Range.Interior.ColorIndex. I assume you mean xlColorIndexNone instead. For Each rCell In Range("F5:F" & LastRow) With rCell If IsNumeric(.Value) Then _ If .Interior.ColorIndex < xlColorIndexNone Then _ dResult = dResult + .Value End With Next rCell In article , RyanH wrote: I need to sum cells in Range("F5:F" & LastRow) that have a Interior Color Index < 0. Is there an easy way to do this? Thanks is Advance, Ryan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum all Cells with Interior Color Index not equal to 0
I should have thought of that, thanks for the help!
Ryan "JE McGimpsey" wrote: One way: First, 0 is not a valid value for Range.Interior.ColorIndex. I assume you mean xlColorIndexNone instead. For Each rCell In Range("F5:F" & LastRow) With rCell If IsNumeric(.Value) Then _ If .Interior.ColorIndex < xlColorIndexNone Then _ dResult = dResult + .Value End With Next rCell In article , RyanH wrote: I need to sum cells in Range("F5:F" & LastRow) that have a Interior Color Index < 0. Is there an easy way to do this? Thanks is Advance, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by Cells Interior Color Then by Date | Excel Programming | |||
How to change the default interior color palette index in Excel 2003 | Excel Programming | |||
cells interior/color index | Excel Programming | |||
Range based on interior color index? | Excel Programming | |||
Sum all cells with interior color... | Excel Programming |