Allen wrote:
Hi gang,
Is there any way to make a formula conditional depending on whether the
cells in the row referred to are visible or hidden.
What I need to do is create a summary of the sub-sections of a standard
so executives can see the overall but then also have the detailed view
available but not have the summary figures shown.
It would look approximately like this in summary mode:
ISO 27002-10 (Title) 5 8 1 3 6
each column would refer to an areas examined in a security assessment.
Then the expanded version would look like this approx:
ISO 27002-10 (Title)
ISO 27002-10.1 1 0 0 0 1
ISO 27002-10.2 0 2 1 0 0
ISO 27002-10.3 2 0 0 1 0
ISO 27002-10.4 0 0 0 1 3
ISO 27002-10.5 1 5 0 0 1
ISO 27002-10.6 1 1 0 1 1
So those who want a more granular view can get it by just unhiding the
rows but the totals at the chapter level would go away to prevent
reading the data as though there were more instances than reality
because people tend to sum what they see in a glance rather than
realizing that one is a summary line only.
If this is not possible - the client *really* wants this layout - I
would guess the best way is to do two sheets with one the summary view
that references the correct cells in the second, more granular sheet,
right?
Thanks,
Allen
Hi,
Function SUBTOTAL (as it is used by the built-in Data>Subtotals-wizard)
ignores filtered cells and other cells having SUBTOTAL.
What you really want is a database, I think. I'm pretty sure that you
will hit the wall of this calculator very soon.
Greetings,
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
