Hi Guys

I would like to know how i can add several functions to an Excel spreadsheet
that has filters. i would like to have a SUM function that calculates the
total value to each filter, is it possible to have just one function that
calculates the values in each filter.P.S - using Excel 2000

Thanks in advance.