You would add a criteria range and criteria to each SUMIFS formula. I'm not sure where account is in your workbook from post #4, but if you wanted to use DeptBase, it would look like this:
=SUMIFS(Table_Query_from_Timberline_Data_Source[Debit],Table_Query_from_Timberline_Data_Source[Accounting_Date],">=" & EOMONTH($A$3,-1)+1,Table_Query_from_Timberline_Data_Source[Accounting_Date],"<=" & EOMONTH($A$3,0),Table_Query_from_Timberline_Data_Source[DeptBase],$B7)+SUMIFS(Table_Query_from_Timberline_Data_Source[Credit],Table_Query_from_Timberline_Data_Source[Accounting_Date],">=" & EOMONTH($A$3,-1)+1,Table_Query_from_Timberline_Data_Source[Accounting_Date],"<=" & EOMONTH($A$3,0),Table_Query_from_Timberline_Data_Source[DeptBase],$B7)
Bookmarks