Hi,

I have a google worksheet called Transactions… which has 3 columns:

User, Type, Value

I would like to write an expression to return summation of column “Value” for each unique value in column “Type”

For example… if my table has 10 entries

**User Type Value**

Alpha Type A 100

Alpha Type B 200

Alpha Type C 150

Beta Type A 100

Beta Type B 200

Beta Type C 150

Charlie Type A 100

Charlie Type B 100

Then my query should result in

Type Value

Type A 300

Type B 500

Type C 300

I hope someone can help me with this.