I’m trying to figure out how I can do a SUM formula across worksheets and ONLY count the cells on the worksheets that are visible and ignore the cells when the worksheet is hidden.
In the attached – the “cover sheet” tab cells B10:B15 are designed to allow users the ability to hide or unhide cells. Straightforward Yes/No selection.
The formulas in K12:K17 on the same tab count the corresponding cells on all the remaining worksheets F1:F7 (except F2). I’d like this formula to ignore the corresponding cells when the worksheet is hidden.
Example – I select NO in cell B12 on the Cover Sheet Sheet Tab. This hides the Call Center tab from view. I don’t want any of the data in the call center tab cells F1:F7 to be counted on the Cover Sheet tab.
I can’t use VBA code as we have users who are using MAC devices –