Sum filtered values only
 

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.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=383069

Hi,
you can use SUBTOTAL.

=SUBTOTAL(9,A1:A100)

The 9 is for the sum value

others will give you averages, counts etc.

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=383069

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


"claytorm" wrote in
message ...

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.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile:
http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=383069