conditional sum ??

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

COOL!, that works... Thanks!

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)