TEED2019Copper ContributorMar 03, 2023SUMIF BASED ON MULTIPLE RANGE WITH SINGLE CRITERIA Dear All, I need help to sort out Summing value based on single criteria with Multiple range selection. Thanks, TEED2019 Show More
OliverScheurichGold ContributorMar 03, 2023TEED2019 =SUMPRODUCT(($B$2:$H$8=N2)*$A$2:$A$8)An alternative could be SUMPRODUCT.
