Hidden rows and sum

[rjdraina]

How can I use the sum button and not include hidden rows
in the sum? The help feature only gives me an example if
using a pivot table, not a standard spreadsheet.

 

[Manish Bajpai]

Simly select the cells on the visible rows, for instance ,
you want to add visible cells of column C, from Row 1 to
10 , of which rows 2 to 9 are hidden, then,just say
+C1+C10) !!!

Regards,

Manish

 

[Don Guillett]

I think you will have to use the SUBTOTAL function.

 

[RagDyer]

While Subtotal() can be used on ranges with rows hidden by filtering, only
the newer versions of XL will allow Subtotal() to be used on ranges with
*manually* hidden rows.

One approach for older versions, is to select the range containing the
manually hidden rows, then <F5> <Special>, click on "VisibleCellsOnly",
<OK>.
Now, right click in the selection and copy, and paste to another location,
and then use Sum().
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I think you will have to use the SUBTOTAL function.