Calculate Total using specific values is list of mulitple items

[mrs.scott]

I am pretty sure this is an easy question but I have no idea how to create the formula that I need. Please help!

I have an excel workbook that has multiple inventory items on it. Certain items are being marked to "keep", "sale", or "scrap".

At the top of the sheet I have a total row. I need for this row to show the true total quantity of all keep, sale and scrap items.

So my total row wold look something like this:

A1 Keep (B1) XXXXXXXX
A2 Sale (B2) XXXXXXXX
A3 Scrap (B3) XXXXXXXX

So I need a formula that looks at my data and sees in column C5 that I have "scrap" in that column and then for it to look in column B5 to get the quantity of each row. And then add all of the quantites for all "scrap" items together and return that one value to my summary column at the top.

A5 B5 C5
Item # Qty Action (Scrap, Keep, Sale)
1 100 Scrap
2 50 Keep
3 60 Scrap

Please help if possible!


Thanks!!

 

[mrs.scott]

Scrap	??? Formula to calculate Scrap Only
Sale	??? Formula to calculate Sale Only
Keep	??? Formula to calculate Keep Only
Item Number	Qty	Action
123	100	Keep
456	50	Scrap
789	60	Sale
321	80	Scrap
654	10	Keep

<tbody>
</tbody>

 

[Smitty]

Welcome to the Board!

You can use SUMIF:

Excel 2010
	A	B	C
1	Scrap	130
2	Sale	60
3	Keep	110
4
5	Item Number	Qty	Action
6	123	100	Keep
7	456	50	Scrap
8	789	60	Sale
9	321	80	Scrap
10	654	10	Keep
Sheet1

Cell Formulas
Range	Formula
B1	=SUMIF($C$6:$C$10,A1,$B$6:$B$10)
B2	=SUMIF($C$6:$C$10,A2,$B$6:$B$10)
B3	=SUMIF($C$6:$C$10,A3,$B$6:$B$10)

HTH,

 

[mrs.scott]

Thank you so much, Smitty! That is exactly what I needed.