Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional sum ??
I have a simple formula...
=SUM(C61:AY61) The cells represent open slots in a fiber switch. some of the cells are colored gray to represent no hardware installed for that slot. is there a way to have the formula only add the cells that are not gray? I didnt see any color options in conditioanl formatting. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional sum ??
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kevin" wrote in message ... I have a simple formula... =SUM(C61:AY61) The cells represent open slots in a fiber switch. some of the cells are colored gray to represent no hardware installed for that slot. is there a way to have the formula only add the cells that are not gray? I didnt see any color options in conditioanl formatting. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional sum ??
COOL!, that works... Thanks!
"Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.ColourCounter.html for a working solution -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kevin" wrote in message ... I have a simple formula... =SUM(C61:AY61) The cells represent open slots in a fiber switch. some of the cells are colored gray to represent no hardware installed for that slot. is there a way to have the formula only add the cells that are not gray? I didnt see any color options in conditioanl formatting. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
Conditional Min Value | Excel Discussion (Misc queries) | |||
conditional sum | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional sum | Excel Worksheet Functions |