Subtotals of Items in A Column based on Spec. Values found in Colu
 

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.

Subtotals of Items in A Column based on Spec. Values found in Colu
 

=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.