Results 1 to 5 of 5

Subtotal for hidden sheets

Threaded View

kimrh Subtotal for hidden sheets 07-31-2015, 10:04 AM
morevijay1982 Re: Subtotal for hidden sheets 08-01-2015, 04:49 AM
kimrh Re: Subtotal for hidden sheets 08-06-2015, 10:57 AM
FDibbins Re: Subtotal for hidden sheets 08-06-2015, 10:59 AM
kimrh Re: Subtotal for hidden sheets 08-06-2015, 11:15 AM
  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    34

    Subtotal for hidden sheets

    Hi,

    I want to sum several cells on different sheets, but only include the cells if the worksheet is visible.

    Subtotal 109 can be used to exclude cells when row or column is hidden, but how to make this work when the entire sheet is hidden?

    / Kim
    Last edited by kimrh; 08-06-2015 at 11:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Format all cells in all sheets to Protection Hidden on visible and hidden tabs
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2014, 03:17 PM
  2. [SOLVED] trying to access the excel sheets/Tabs in the hidden/very hidden mode through hyperlinks
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2013, 06:50 AM
  3. [SOLVED] Subtotal and hidden columns
    By Anat in forum Excel General
    Replies: 0
    Last Post: 04-18-2006, 07:45 PM
  4. using SUBTOTAL() on rows that have been hidden
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2005, 07:05 AM
  5. using SUBTOTAL() on rows that have been hidden
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] using SUBTOTAL() on rows that have been hidden
    By doco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] using SUBTOTAL() on rows that have been hidden
    By doco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. using SUBTOTAL() on rows that have been hidden
    By doco in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1