This week we will learn about 3D formulas What are these Can

This week we will learn about 3D formulas. What are these? Can you provide examples?

Solution

3D reference formulas are used to calcualte the operations that demands performing an operation to the same cell or range of cells on multiple worksheets.

Working

Suppose there are three sheets Jan, Feb, Mar,

SUM - adds up numerical values - In 3D reference this will be =SUM(\'JAN:MAR\'!B2)

This will add the sum

AVERAGE - calculates arithmetic mean of numbers.In 3D reference this will be =AVERAGE(\'JAN:MAR\'!B2)