=sum(a1..a2)+sum(a4..a5) and so on and so on and so on

--
Rui

"Led_A_Muck" wrote in message
...
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.