LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Keeping the total of filtered data

Hi there,

I have a list of data in columns and have added a total in each column at
the bottom row. When I filter my data my totals row disappears as well. I
tried defining my data, sum(), subtotal(9; ) but still the totals disappear.

I've read some similar questions and one solution is to place my totals
above the filtered area. This however does not fit the setup of my data so I
want the totals below the filtered data not at the top.

Does anybody have any ideas?
Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
total on filtered data? martyn Excel Worksheet Functions 3 September 5th 06 02:50 PM
KEEPING THE TOTAL IN C3 WHEN ADDING B3 bouncer8 Excel Discussion (Misc queries) 3 August 19th 06 01:21 AM
KEEPING THE TOTAL IN C3 WHEN ADDING B3 bouncer8 Excel Discussion (Misc queries) 1 August 18th 06 02:41 PM
Keeping an acculumative total in a row and only that row. Sherry Excel Worksheet Functions 2 January 7th 06 08:35 PM
How to have total for filtered data?? Derrick Excel Discussion (Misc queries) 2 March 10th 05 02:41 AM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"