search and sum

[audkb2002]

Is there a way to search for matches and then sum other cells pertaining to those matched? Let's say I have rows and each has a column of classes (with AC, DC, DM) and a column of quantity. Is there a way to find all rows that = AC and add up all the quantities for AC?

AC 10
DC 10
DC 10
DM 10
AC 10

So basically, I want something to get the results AC=20, DC= 20, DM=10...

Thanks in advance.

 

[zacemmel]

http://www.excelquestions.com/tips.php

Check that out. You will find the sumif.xls to be helpful.

 

[Aladin Akyurek]

On 2002-10-25 18:26, audkb2002 wrote:
Is there a way to search for matches and then sum other cells pertaining to those matched? Let's say I have rows and each has a column of classes (with AC, DC, DM) and a column of quantity. Is there a way to find all rows that = AC and add up all the quantities for AC?

AC 10
DC 10
DC 10
DM 10
AC 10

So basically, I want something to get the results AC=20, DC= 20, DM=10...

Thanks in advance.

In C2 on enter: AC, DC, DM

In D2 enter & copy down:

=SUMIF($A$2:$A$6,C2,$B$2:$B$6)

 

[Mark W.]

Have a look at Exce's PivotTable functionality...

Book1
	A	B	C	D	E	F	G	H	I	J
1	Class	Quantity			SumofQuantity
2	AC	10			Class	Total
3	DC	10			AC	20
4	DC	10			DC	20
5	DM	10			DM	10
6	AC	10			GrandTotal	50
7
8
Sheet5