Andrew,

Sorry for the ramble, trying to make the most sense out of it as possible.

I have found out that the problem is the hidden cell values are being added on. However, my one remaining question is how to make sure that hidden cell does not reappear?

When I switch from collapsed to expanded view, the hidden cell keeps being placed in the formula.



Thanks Andrew