I am attempting to sum across multiple tabs based on multiple criteria but am #REF! Below is my formula:
-SalesGroup is a Defined Name for a list of tabs
-$F$F is the sum range
-$X$11 and $X$1 are the cells referencing the criteria, with column B and P the corresponding columns in the tabs
=SUMPRODUCT(SUMIFS(INDIRECT("'"&SalesGroup&"'!$f:$f"),INDIRECT("'"&SalesGroup&"'!$b:$b"),$X11,INDIRECT("'"&SalesGroup&"'!$p:$p"),$X$1))
-SalesGroup is a Defined Name for a list of tabs
-$F$F is the sum range
-$X$11 and $X$1 are the cells referencing the criteria, with column B and P the corresponding columns in the tabs
=SUMPRODUCT(SUMIFS(INDIRECT("'"&SalesGroup&"'!$f:$f"),INDIRECT("'"&SalesGroup&"'!$b:$b"),$X11,INDIRECT("'"&SalesGroup&"'!$p:$p"),$X$1))