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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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?
 
Upvote 0

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:
 
Upvote 0

Forum statistics

Threads
1,186,364
Messages
5,957,427
Members
438,305
Latest member
farmerje

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