Hi,

How to set excel function or formula such as SUM function to add up
the range of selected cells which gives the result excludes hide
cells, particularly for long range of cells in a column ?


E.g.

In this case, the result excludes hide cells will be 10,086.40 ( ie
A1+A4+A5+A6+A8+A9 ) and not 10,884.00 ( ie adding up cells from A1 to
A10 )
A
1 4,084.20
2 300.00 ( Hide cell )
3 450.00 ( Hide cell )
4 3,965.00
5 200.00
6 50.00
7 47.00 ( Hide cell )
8 1,037.20
9 750.00
10 0.60 ( Hide cell )
---------------------
10,086.40 ( Sum up exclude hide cells )
==========

Please help, thanks

Regards
Lenard