Sum of the autofiltered data

Posted by MM on November 08, 2001 12:58 AM

Dear Excel Professionals,

How can I count the sum of an autofiltered column of numbers? I have a formula that counts the visible cells after an autofiltering:
=SUBTOTAL(2;I11:I19).
Could this formula be altered or do I need something completely different?

Thanking you in advance,

Posted by Dank on November 08, 2001 3:47 AM

Unless I'm misunderstanding your request just use this:-

=SUBTOTAL(9,I11:I19).

Hope it helps,
Daniel.