When you have data on multiple worksheets and want to consolidate that data into a summary worksheet,you can use a 2-D formula.

Name: When you have data on multiple worksheets and want to consolidate that data into a summary worksheet,you can use a 2-D formula.
Brand: Quizplus
Rating: 4.8 (41 reviews)

Question

Quizplus · Accepted Answer

A 2-D formula refers to a formula that works within a single worksheet. To consolidate data from multiple worksheets, you typically use a 3-D formula or other methods like consolidation tools or functions like SUM across sheets.

When You Have Data on Multiple Worksheets and Want to Consolidate