Hi,

Came across one more problem.

Example:

(Animal) (Colour) (No. of hunts)

Tiger Yellow 2
Tiger Yellow 3
Tiger Yellow 5
Panther Black 4
Panther Black 3
Cat Pink 2
Cat Pink 3

How can i make it as mentioned below with a formula?

Tiger Yellow 10
Panther Black 7
Cat Pink 5

PLEASE HELP, would really appreciate it....