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
|