I assume there is a reason you need to keep the formulae? If so, you
could copy the the column to a new column using Paste Special/Values &
then use the filter.

Alternatively, you may want to look at some of the Database functions
(DGet, DSUM, DCOUNT, etc).

--Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=523242