View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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.