If the SUM cell is in a hidden row, it will remain hidden.

Where is SUM and what cells are hidden?

"Bec" wrote:

Hi I have created a worksheet with the unused cells hidden. i want to do an
auto sum but the total does not show. how do i get the total to show on the
last cell but not on the hidden one
Thanks