Applying functions to only cells selected through filtering

impetuous1one

New Member
Joined
Jul 30, 2002
Messages
13
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!! :oops:
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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

New Member
Joined
Jul 30, 2002
Messages
13
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 :oops:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,882
Messages
5,766,896
Members
425,383
Latest member
IllDo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top