Formula for Auto filter
 

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.

Formula for Auto filter
 

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

"Mike Busch" wrote:

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.