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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks