Help to create a "3 Dimensional Reference" Formula

Carole M.

I am trying to create a sum of the same cell in four different Metrics Sheets. I have created the following formula and I get the Unparseable error. Would appreciate help, please.

Carole M.

Sure…Instead of creating a formula to summarize YTD numbers, I used the link function to pull all the data for each quarter then summarized it.

Carole M.

For some reason the formula did not show up in original request. Here is formula

Archiduc

You seem to have double accolade everywhere, I've never seen that, is that normal? {{ }} I usually only have one to open and one to close my references { }

Carole M.

If I take the second set away, it gives me a Circular reference error.

Yvonne Smythe

Hi @Carole M. - Perhaps this will provide a baseline for you. Hope it helps! 🙂

=SUM({01_Metrics Sheet_Complaints-QTR1_2025 Range 1}, {01_Metrics Sheet_Complaints-QTR2_2025 Range 1}, {01_Metrics Sheet_Complaints-QTR3_2025 Range 1}, {01_Metrics Sheet_Complaints-QTR4_2025 Range 1})

Carole M.

Thanks all. I found a different way to do the same thing.

Georgie

Hi @Carole M.,

Glad to hear you were able to figure this out! Could you share the solution you found to help others reviewing this thread?

Thanks,

Georgie

Carole M.

Sure…Instead of creating a formula to summarize YTD numbers, I used the link function to pull all the data for each quarter then summarized it.