Use the SUBTOTAL function.

=SUBTOTAL(9,A1:A5000)

This function ignores the filtered items.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 09:29:04 -0800, BJ Magill <BJ
wrote:

Please could someone let me know which solution is best for totals
calculating whilst using AutoFilter. I have list of projects (Alive or Dead)
with a total cost for each and a main total at bottom. If I autofilter on
Alive only the total remains for both Alive and Dead projects. Please Help ?