software

I have a total field in a workbook. I run an autofilter, and it shrinks the
records down to a few, is there anyway to have the filtered fields total the
total field everytime I search per filter. Thanks in advance.

Are you asking that the records that pass the filter be totaled? If so, the
subtotal function will do the trick. If you've currently got the formula
=sum(range), then use =subtotal(9,range) instead. Note that if you've got an
autofilter set with one or more active criteria, the autosum button will
create the subtotal function (rather than sum) for you.
--Bruce

quot;Mike Buschquot; wrote:

gt; I have a total field in a workbook. I run an autofilter, and it shrinks the
gt; records down to a few, is there anyway to have the filtered fields total the
gt; total field everytime I search per filter. Thanks in advance.