I can't use the tool because I'm on a work computer and it won't let me download it, I've tried.
In the example sheet for the Month I've got it as a table and it's data from a month of business. I'd like to total each month's # of trans for each Table ID, the amount of vouchers, the Fees and then the totals for the Vouchers plus the Fees in the YTD sheet.
The YTD sheet layout is the named range MonthTabs in Column A and the rest follow out.
On the Month sheets the Table ID column is A and they move out to B, C, D and E.
They start on row 2, row 1 is just totaling the individual columns and not to be included in the formula.
The formula >>> SUMPRODUCT(SUMIFS(INDIRECT("'"&MonthTabs&"'!$B3:$B50"),INDIRECT("'"&MonthTabs&"'!$A3:$A50"),$B3)) In this formula $B3 is referring to the Table ID on the YTD sheet, this is the unique identifier that I'll use to match up the data across the worksheets for each month. So I have that pointing at the column on each Month sheet to match up those Table IDs and return the appropriate data from the column I reference first, have I done that right?
$A$3:$A50 is the range of Table IDs on every sheet for each Month,
$B$3:$B$50 is the range of # of Trans on every sheet for each Month,
$C$3:$C$50 is the range of Voucher Amounts on every sheet for each Month,
$D$3:$D$50 is the range of Fee Amount on every sheet for each Month
The Total Amount is just a Sum of Voucher and Fee amounts.
My apologies for not being able to give you an actual worksheet.
