I am trying to figure out how to calculate the value. best example I can think of is if A:A = value of typed in value at Q10 than count number in C:C. so if it searches the A:A field and finds a match in the Q10 cell it will calculate the totals of the numbers in cell 3.
A C Q
and so on ...
and I type Frog into Q10 then on R 10 it give me the total Frog 5