Remember Me?

#1
 Derrick Posts: n/a
How to have total for filtered data??

I have a table with detailed sales data by product by
country. There is a grand total at the end of the sales
for a total sales revenue.

I did a auto filter and I selected the country I want to
focus. Noticed that the grand total number doesn't
change. I want it to show only the total revenue of the
contry I've selected.

Can anyone help? Thanks.
#2
 Debra Dalgleish Posts: n/a

You can use the SUBTOTAL function. There are instructions he

http://www.contextures.com/xlFunctions01.html#Filter

Derrick wrote:
I have a table with detailed sales data by product by
country. There is a grand total at the end of the sales
for a total sales revenue.

I did a auto filter and I selected the country I want to
focus. Noticed that the grand total number doesn't
change. I want it to show only the total revenue of the
contry I've selected.

Can anyone help? Thanks.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

#3
 Biff Posts: n/a

Hi!

Use SUBTOTAL. There are several actions that you can use
with SUBTOTAL so see Excel help. Basically, SUBTOTAL will

Biff

-----Original Message-----
I have a table with detailed sales data by product by
country. There is a grand total at the end of the sales
for a total sales revenue.

I did a auto filter and I selected the country I want to
focus. Noticed that the grand total number doesn't
change. I want it to show only the total revenue of the
contry I've selected.

Can anyone help? Thanks.
.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM Savril Excel Discussion (Misc queries) 1 January 4th 05 02:20 AM mikelee101 Charts and Charting in Excel 2 December 17th 04 12:07 AM

All times are GMT +1. The time now is 07:59 AM.