View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy the Yeti Andy the Yeti is offline
external usenet poster
 
Posts: 28
Default auto filter / sumif

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