Only with version 2003.

The SUBTOTAL Function in earlier versions does not accomodate hidden
cells/rows, only filtered cells/rows.

If an earlier version, copy the visible cells to another area or sheet and SUM
them there.


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 11:34:54 +0200, "Niek Otten" wrote:

=SUBTOTAL(109,A1:A20)