Are they hidden due to Filtering? Or why are they hidden.
If hidden due to filtering, read up on the SUBTOTAL function.
If not, provide more detail, formulas, sample, current result, expected
result.
--
** John C **

"Led_A_Muck" wrote:

How do you use the sum function in a column to add only the cells that are
visable not the hidden ones? I have several cells hidden and when I use the
sum function it adds all cells seen and un-seen.