Formula for Auto filter

[Mike Busch]

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.

[bpeltzer]

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.