I'm trying to sum multiple criteria across columns. My formula is not working properly and might now be the best way to get my desired result.
I'm using 365 as excel version.
Formula I'm using : SUM(XLOOKUP(J4&K4&L4,A$4:A$6&B$4:B$6&D$4:D$6,XLOOKUP(M4,F$3:H$3,$F$4:$H$6)))
SUM(XLOOKUP(J4&K4&L4, A$4:A$6&B$4:B$6&D$4:D$6, XLOOKUP(M4,F$3:H$3,$F$4:$H$6)))
Thank you in advance for any help provided.
Shamus
I'm using 365 as excel version.
Formula I'm using : SUM(XLOOKUP(J4&K4&L4,A$4:A$6&B$4:B$6&D$4:D$6,XLOOKUP(M4,F$3:H$3,$F$4:$H$6)))
SUM(XLOOKUP(J4&K4&L4, A$4:A$6&B$4:B$6&D$4:D$6, XLOOKUP(M4,F$3:H$3,$F$4:$H$6)))
Thank you in advance for any help provided.
Shamus