auto filter / sumif

A

Andy the yeti

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
 
R

Ron de Bruin

Hi Andy

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