Hi Jessica,

It looks like the sheet name is >>:<< and the sum is simply picking up the value in cell S46 of that sheet.

Mynda

The only problem is a worksheet name cannot have a colon. Probably it is a semi colon

Hi Mynda and Sunny,

Thanks for your prompted reply, really appreciated. I finally saw the actual file and worked it out.

It was a very smart way of summing up the same cell from a group of sheets.

E.g if I want to sum up cell A1 in sheet 1, 2, 3, 4 & 5, I would normally use formula =SUM(Sheet1:Sheet5!A1), but if I need to add more sheet(s) to the group, I have to either update sheet name for the last tab in the formula or make sure the added sheets are in between Sheet 1 & Sheet 5. 

This smart person added a blank sheet called ">>" at beginning of the group sheets and another blank sheet called "<<" at the end. So the formula became =SUM('>>:<<'!A1), so you can add any no. of sheets to the group in any order without the need to update the formula.

We learn something new everyday! 🙂

Thanks again for your help and have an awesome day!

Cheers!

Jessica

That's nice trick. I love it

Hi Jessica

When doing 3D summing, make sure that the new sheet(s) are added between the first sheet ">>" and last sheet "<<" else it won't be included in the sum.

Example. If you add a new sheet before the sheet ">>" or after the sheet named "<<", it will not be summed.

Sunny

Thanks Sunny,

That's what I meant about the GROUP (all tabs in between the ">>" and "<<"), thanks for making it clearer.

You are awesome! 🙂

Cheers!

Jessic