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

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

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