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

B

Brad

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

Mike

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

looking up cell value based off of row and column information 1
Macro to add numbers in a text string 5
Formula to sum based on a change in another column 2
i wish to lookup values in column A, & add adjacent values in colu 4
Sum a range based on a column 2
Sum formula 4
insert row when sum of values equals 100 2
insert row when sum of values equals 100 3

Top