auto filter / sumif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is it possible to have a cell value, equal the criteria met in an auto
filter? The purpose would allow me to have a dynamic sumif formula based on
the value of the auto filter. The sumif formulae would then update as I
changed the value that the filter met?

Thank you for any help
Andy
 
Hi Andy

Maybe you want to use the Subtotal function
The function only sum visible data
 
Back
Top