Forum Discussion
Pull different data from different sheets
Hi, I have one workbook with 3 sheets and all sheets are same format but the data in each cell is different - how can I link each cell data from all three sheets adding them up together into shee...
You can do that with a formula like this:
=SUM(Sheet1:Sheet3!D33)
This is called a 3-D reference. Read more about how it works here: https://support.microsoft.com/en-us/office/create-a-3-d-reference-to-the-same-cell-range-on-multiple-worksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6?wt.mc_id=MVP_349323
=SUM(Sheet1:Sheet3!D33)
This is called a 3-D reference. Read more about how it works here: https://support.microsoft.com/en-us/office/create-a-3-d-reference-to-the-same-cell-range-on-multiple-worksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6?wt.mc_id=MVP_349323