It wasn't clear what the solution was from previous posts so I thought I ask
the question again.

I essentially want a function that can look at 1 column for a specific
criteria and then sum a 2nd column when the criteria is found. So for
examples

C1 C2
Red 9
Green 10
Red 2
Blue 6
Yellow 22
Red 18
Brown 23

I want something that will give me the sum of the number associated with red
but for many more data points than this.