Only Add Values If Tab is Visible

[margal]

Hi everyone!

im after a little help with a formula

The current formula I use which works is as follows

=IFERROR(SUMPRODUCT(SUMIF(INDIRECT("'"&$Q$14:$Q$19&"'!$d$27:$d$300"),G737,INDIRECT("'"&$Q$14:$Q$19&"'!$E$27:$E$300"))),"")

Im in directing tab references which are numbers, it calculates all items across all pages that reference the indirect of G737

I want to hide tabs which I deep hide, but the formulas is still adding the values of items that are deep hidden.

I need to be able to add a subtotal 109 so it only adds the values if the sheet is visible.

Can anyone help with this please?

Much appreciated all!!

[JohnTopley]

I am not aware of any formula which will allow hidden sheets to be excluded from a calculation. You will need VBA to do this and you "deep hide" your sheets using VBA anyway (?)