this formula works, but is there a way to shorten it since its referencing
to only one table

=SUMIFS(INDIRECT($B7&"[Credit]"),INDIRECT($B7&"[Group]"),$C$6,INDIRECT($B7&"[Sub-Group]"),$C7,INDIRECT($B7&"[Date]"),">="&Accounts!$H$2,INDIRECT($B7&"[Date]"),"<="&Accounts!$I$2)


Thank you!