Hi Len,

If the cells were hidden as the result of a filter (or if yuo are using a
recent version of Excel, try the SubTotal function:

=SubTotal(9, A1:A10)

See Excel help for nore details.



---
Regards.
Norman


"Len" wrote in message
...
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