| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
Hi Vishnu
Insert a row above your Autofilter Use the Subtotal function =SUBTOTAL(9,D3  1000)Change the range to suit Copy across to any other columns required. -- Regards Roger Govier <(E-Mail Removed)> wrote in message news:5d5f47fb-debe-4408-a17d-(E-Mail Removed)... > Hi All, > > I have a table in which I am performing an autofilter for column d and > then I would like to find the total across each column in the > remaining visible rows. > Then I would like to generate a new table with these totals across > columns for the selected filter criteria. > > Can anyone help me with this? > > I have been stuck in this for a while now. > > Thanks > vishnu |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Autofilter and subtotal | stevefromnaki | Microsoft Excel Programming | 1 | 14th Jan 2010 05:58 AM |
| SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER | Donovan | Microsoft Excel Worksheet Functions | 4 | 9th Jun 2006 12:06 AM |
| After I set up an autofilter on a spreadsheet, how can I subtotal. | Patti | Microsoft Excel Worksheet Functions | 0 | 15th Sep 2004 08:41 PM |
| Autofilter (subtotal) | Dargo | Microsoft Excel Misc | 3 | 14th Mar 2004 09:19 AM |
| autofilter-subtotal-problem | Walter Mayes | Microsoft Excel Worksheet Functions | 4 | 8th Jul 2003 08:10 PM |
