Can I sum an outlined Excel sheet and ignore collapsed rows?

[DennisB]

How can I sum a column of data values in an outlined Excel worksheet while
ignoring collapsed rows? I'd like to sum only the values that can be seen
on the worksheet, not in the rows that I've collapsed.
Thanks

[Gord Dibben]

Dennis

=SUBTOTAL(9,A1:A100 will SUM up only the visible cells.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 17:50:02 -0700, DennisB <DennisB@discussions.microsoft.com>
wrote:

>How can I sum a column of data values in an outlined Excel worksheet while
>ignoring collapsed rows? I'd like to sum only the values that can be seen
>on the worksheet, not in the rows that I've collapsed.
>Thanks

[Franz Verga]

Nel post news:3DAAC09F-F118-4BC9-A5A7-B9CDFF5D53AB@microsoft.com
*DennisB* ha scritto:

> How can I sum a column of data values in an outlined Excel worksheet
> while ignoring collapsed rows? I'd like to sum only the values that
> can be seen on the worksheet, not in the rows that I've collapsed.
> Thanks

Hi Dennis,
You can use the SUBTOTAL function:

=SUBTOTAL(109;your_range)

your_range includes also the hidden rows.

For more specifications see the on line help.

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy