A:A = B Count C:C [Closed]

Report
-
Hello,
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
Apple 10
Box 7
Frog 3
Carrot 1
Frog 2
and so on ...
and I type Frog into Q10 then on R 10 it give me the total Frog 5


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!