PDA

View Full Version : Need help with INDIRECT formula



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!