Forum Discussion
odko221100
Jul 10, 2022Copper Contributor
Sum of range in column
Hi, could anyone please help me to solve following problem? I have a set of data as shown in left side and want to have result as shown in right side. I tried to use sumproduct but still cant find ...
Riny_van_Eekelen
Jul 10, 2022Platinum Contributor
odko221100 Two possible solution. One with SUMIFS. Another with SUMPRODUCT. See which one suits you best. Examples in the attached file.
odko221100
Jul 10, 2022Copper Contributor
Riny_van_Eekelen Oh, Thank you very much!!!!