I have an excel spreadsheet with three tabs: Summary, Data and Settings.
In the summary tab i want to use a a formula that shows balances across the columns per each account in each row. The formula will read from the data tab where I have define names for each column as Per1, Per2, Per3.
so, the summary tab will return Bal_2 as the sum of Per1 and Per2; Bal_3 as the sum of Per1...Per3
I have used sum products and sumifs, but I think the issue I have is that sumifs won't sum range more than one column. See my spreadsheet attached.