Hello,
Currently, as shown below in Sheet1 ... a helper column generates the True/False for all the last occurrences of the combined ranges : Names and Types
Then, Column E allows to sum individual Types A,B,C ...
The objective is to do without the Helper Column C ... in a combined Array...