Thread
:
Autofilter not recalculating totals
View Single Post
#
3
Gord Dibben
Posts: n/a
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 ?
Reply With Quote