View Single Post
  #2   Report Post  
Damon Longworth
 
Posts: n/a
Default

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