Hi,

I have a range that I want to be dynamic since I will be inserting and deleting rows in the dataset. Out of this dataset, I would like a formula based solution to create a list of only upper-cased names and sum the values of the numbers associated with the name. In my example below, I am using "-" as column separators.


AA - 10 - BB - 5
Aa - 5 - CC - 15
E1 - 7 - AA - 10
gg - 10 - DD - 5
DD - 5 - E1 - 3


Results:

AA - 20
BB - 5
CC - 15
DD - 10
E1 - 10


Thanks,

PAExcel