=SUMPRODUCT((C1:C5=6.25)*A1:A5) Hard code the 6.25
=SUMPRODUCT((C1:C5=D1)*A1:A5) Use cell D1 to hold the value your looking
for
"Brad" wrote:

I need to find all occurances of a specific value in Column C and add the
corrisponding values in Column A.
A B C
1 25 ea 6.25
2 10 ea 5.50
3 10 ea 6.25
4 5 ea 8.75
5 15 ea 6.25

I want the formula to give me the sum of the quantity every occurance of
6.25 which in the example above would equal 50.
Thanks for your help.