Hi
I am currently use this formula in a workbook with no problem and get the results I expect;
=SUMPRODUCT(--('ACF2019'!$E:$E=Summary2019!A6),'ACF2019'!$K:$K)
I need to change this so that it will sum for the same criteria (Summary2019!A6) but i need to multiply the values in Column K & Column H of 'ACF2019 for each instance, is this possible using SUMPRODUCT?
Thanks in advance
Jeremy
I am currently use this formula in a workbook with no problem and get the results I expect;
=SUMPRODUCT(--('ACF2019'!$E:$E=Summary2019!A6),'ACF2019'!$K:$K)
I need to change this so that it will sum for the same criteria (Summary2019!A6) but i need to multiply the values in Column K & Column H of 'ACF2019 for each instance, is this possible using SUMPRODUCT?
Thanks in advance
Jeremy