jamesbowers
05-27-2019, 12:50 AM
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!
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!