LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dane
 
Posts: n/a
Default SUBTOTAL(9,range) Does NOT work in AutoFilter

I have used this function before and had no problem.
I do not understand why it is not working for me now.
I have approx. 1600 rows of data and I have three columns with the subtotal
function entered in the row under the last row of data.

When I filter on a specific the data value in one column that I want to get
a subtotal for, the row wihere the subtotal function is entered does not
display.

Can someone help with this problem please.
 
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
Tab key don't work in unprotected cells in a protected sheet Chad Excel Discussion (Misc queries) 0 August 16th 05 02:00 AM
Autofilter on protected work book? Muppet Excel Discussion (Misc queries) 1 August 6th 05 08:56 AM
Some Excel links don't work Ben Enfield Excel Discussion (Misc queries) 3 August 2nd 05 12:29 AM
Using AutoFilter with worksheet protection in 2000 vs. 2003 gncook Excel Discussion (Misc queries) 3 July 25th 05 08:02 PM
creating an invoice for work Beth Excel Worksheet Functions 4 July 16th 05 09:25 PM


All times are GMT +1. The time now is 02:12 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"