How do I calculate only visible data (not hidden rows)?

[Peter]

When I sort some data and hide rows or columns formulas are calculating using
the entire database (including hidden rows). I'd like to calculate only
'visibe' data.

[Pete_UK]

Use SUBTOTAL( ) to act on only visible rows. For example, the formula:

=SUBTOTAL(9,A1:A100)

(equivalent to SUM) will only add the values in A1:A100 which are
visible.

Other parameters can be used instead of 9 to change the function -
check out Excel Help for a list of them.

Hope this helps.

Pete

Peter wrote:
> When I sort some data and hide rows or columns formulas are calculating using
> the entire database (including hidden rows). I'd like to calculate only
> 'visibe' data.