Applying functions to only cells selected through filtering

[impetuous1one]

I have a hugh list of data that is based on the Month and Year.

I have totals for all the data at the bottom (i.g. sales, number of hours worked)

I have the list filtered and when I choose to view just one month, or one salesperson or one area I'd like the totals to reflect only what I have showing based on the filter I choose.

Is this possible???

Thanks!!

 

[Aladin Akyurek]

Re: Applying functions to only cells selected through filter

Aren't you using SUBTOTAL(9,Range) for totals or is there something more to it?

 

[impetuous1one]

Re: Applying functions to only cells selected through filter

It would have to be that simple...just when I think I know what I am doing......thanks