Forum Discussion

PRESCOTTJH's avatar
PRESCOTTJH
Copper Contributor
Feb 09, 2023
Solved

SUMPRODUCT OVER MULTIPLE TABLES

Hi, I have been trying to use some variation of the SUMPRODUCT function to sum across multiple tables (stacked on top of each other) with more than one criteria.   I wish to display sales figures ...
excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Feb 09, 2023

    PRESCOTTJH 

    I wouldn't stack the data. I think it's best to keep it horizontal and then use FILTER:

    =LET(filtered,FILTER($B2:$AK2,RIGHT(dates,2)=RIGHT(B$11,2),0),SUM(filtered))

Resources