Formula for Auto filter

M

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.
 
B

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
 
Top