auto filter / sumif

[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

 

[Ron de Bruin]

Hi Andy

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

 

[Guest]

Perfect thank you

Hi Andy

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