Good morning
I think a HLookup formula would work best in this instance but struggling to get it to work. So, the attached example shows values in row 2 and the value I want returned in cell C5 is the sum of values in row 2 where the reference in row 1 matches the reference in row 4. I have presented the desired results in cells C5:E5 (I've coloured the cells to make it clearer).
Any assistance would be gratefully appreciated.
Regards
Ben
Bookmarks