Reply
 
Thread Tools Display Modes
  #1   Report Post  
JethroUK©
 
Posts: n/a
Default SUBTOTAL not working?

tried using SUBTOTAL function (XL XP) and it doesn't seem to work

=SUBTOTAL(9,A1:A10) still gives total of rows 1 thru 10 even though i've
hidden rows 5 thru 7

???

is there any other method of working with visible cells only?


  #2   Report Post  
JethroUK©
 
Posts: n/a
Default


"JethroUK©" wrote in message
...
tried using SUBTOTAL function (XL XP) and it doesn't seem to work

=SUBTOTAL(9,A1:A10) still gives total of rows 1 thru 10 even though i've
hidden rows 5 thru 7

???

is there any other method of working with visible cells only?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
delete not working steve Microsoft Word Help 2 October 11th 07 10:03 PM
CPU Usage When Working with Templates you created KM1 Microsoft Word Help 3 May 21st 05 11:57 PM
Word 2003 - File and Tools drowndown menus stopped working Russ Abrams Microsoft Word Help 1 April 30th 05 12:06 PM
Word 97 templates not working properly in Word 2003 limited computer knowledge Microsoft Word Help 0 April 26th 05 02:07 AM
Autocomplete for autotext not working? Dawn Rhoads Microsoft Word Help 1 April 14th 05 01:04 AM


All times are GMT +1. The time now is 06:53 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"