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) ...
I think the following works and is 'dynamic' based on the header in that column:
=SUM(FILTER(TOCOL('Titanium Data:Retail Blend Data'!5:5),D$3=LEFT(TOCOL('Titanium Data:Retail Blend Data'!$3:$3),LEN(D$3)),0))
- This looked like it would work, but I have info that changes in the column. For instance, In T3 Data D15, I need to add cells ('B1 Data'D16:F16,'Retail Blend Data'D16:F16, 'Retail Blend Data'D19:F19,'Retail Blend Data'D22:F22)
- If you need different formula for different rows it will need to change. I don't know what you need for each of those values. The formula I gave you will automatically sum up ACROSS that range of tabs/sheets the values 1 row 'lower' where the column header starts with the same header on this page. NOTE: I notice the formula had 3:3 and that should be $3:$3 so it always looks at the header on those pages.
That said, for row 15 telling me it needs to add up those somewhat random ranges isn't that helpful. but you can use the same 'format' to automatically find and filter the appropriate columns for those rows you need.
