tags:

views:

19

answers:

1

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

A: 

repeated question so I just want to close this one.. sorry

Tolga