Sum filtered values only

  • Thread starter Thread starter claytorm
  • Start date Start date
C

claytorm

Hi,

I have filtered a long list of values. Is there a way I can perform
calculations only on the filtered values? I want to ignore values which
have been hidden after the filter has been applied.

Thanks,

Bertie.
 
Hi,
you can use SUBTOTAL.

=SUBTOTAL(9,A1:A100)

The 9 is for the sum value

others will give you averages, counts etc.

HTH.
 
Have a look at the Subtotal function in help.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average value only for the filtered area.. 4
Filtering with SUMIFS 1
AutoSum/Subtotal Inclusions/Exclusions 2
Excel 2007 compatibility issue - speed between cells 2
Filtering issues? 2
Do not count hidden cells 2
How to bind filtered data in list box? 1
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top