Hi,
I have a table that features numbers and types. I want to take the maximum
number from each type and sum all the those numbers together.
The types can vary and are not known in advance.

For example look at the following table:

type number
green 1
red 12
box 31
pyramid 2
steel 5
green 10
pyramid 7
green 9
steel 11

I want to get the maximum of each type:
red = 12
green = 10
box = 31
pyramid = 7
steel = 11

and sum them up:
total = 71

Is there any simple way to do it? once again, the types are unknown.

Thanks