farrusete Member Apr 21, 2015 #1 Hi, Im trying to sum columns from a table based on values in different cells. Something like =SUM(Table1["Invoicing "&B16&"-"&C15]) Is this possible? (excel attached) Thank you in advance Attachments test.xlsx 12.1 KB · Views: 0
Hi, Im trying to sum columns from a table based on values in different cells. Something like =SUM(Table1["Invoicing "&B16&"-"&C15]) Is this possible? (excel attached) Thank you in advance
Luke M Excel Ninja Staff member Apr 21, 2015 #2 You're on the right track. You were looking for the INDIRECT function, which lets you build a string which XL then interprets as a range. formula in C16 would be: =SUM(INDIRECT("Table1[Invoicing "&$B16&"-"&RIGHT(C$15,2)&"]"))
You're on the right track. You were looking for the INDIRECT function, which lets you build a string which XL then interprets as a range. formula in C16 would be: =SUM(INDIRECT("Table1[Invoicing "&$B16&"-"&RIGHT(C$15,2)&"]"))
