Forum Discussion
Help with excel formula
Hello, I need some help linking multiple sheets. I need to pull data into ‘T3 Data’ D4, from (‘Titanium Data’ D5,E5)&(‘Dryer Data’ D5,E5,F5)&(‘B1 Data’ D5,E5,F5)&(‘Retail Blend Data’ D5,E5,F5) ...
You could write a formula that uses the + operator between each of those fields, but that becomes lengthy. A better approach is to take advantage of Excel's SUM function, which can add literal numbers and/or values from individual cells and/or values in ranges of cells. Try this:
=SUM('Titanium Data'!D5:E5, 'Dryer Data'!D5:F5, 'B1 Data'!D5:F5, 'Retail Blend Data'!D5:F5)
How would I "lock" that range of cells when I drag it over? In this case, I need it to add the three cells from each day (three shifts), but in future sheets, I will be adding areas that only work two shifts.