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 sheet 3.
example: D33 in each sheet will have different data and want to add sheet 1, 2 and 3 together in D41. Can this be done or am I wayyyyy out of my league in what I want?
Hope someone call help - thanks in advance.
Lin
- 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
