You are welcome Spinks.

It may still be that Mike is also right about you having SUBTOTAL()'s at the
end of the hidden data, (ie the cell that you can see), because SUBTOTAL()
ignores other SUBTOTAL()'s and so a final SUBTOTAL() at the bottom will not
add in all the intervening SUBTOTAL()'s

--
Regards,


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Sprinks" wrote in message
...
Sandy,

Thank you. That's what it is.

Sprinks

"Sandy Mann" wrote:

I assume that you have data Grouped. Highlight the data that you want to
Group then select Data Group ans Outline Group

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Sprinks" wrote in message
...
I recently received a project estimate that had three levels of exploded
views--byclicking on a plus sign, the information expands to more
detail.
Also, the spreadsheet had a window on the left side with buttons
labeled
1,
2, and 3. Clicking the 1 showed the executive summary view, 3 the most
detailed, and 2 an intermediate level.

Is this native Excel functionality, or does anyone know of an add-in
that
provides it? I would like to incorporate this feature into workbooks
that
we
produce.

Thank you.

Sprinks