I need a quick an simple excel formula to get the sum of values for different types of objects as listed below:
Type1 10
Type1 10
Type1 10
Type 2 10
Type 2 10
Type 2 10
Type 2 10
Type 3 10
Type 3 10
Number of items and number of types are unknown (long list), in a different worksheet I would like to get sum of types like:
Sumof Type1: 30
Sumof Type2: 40
Sumof Type3: 20
I need no VBA, just simple excel formula please..
BR