Adding based on groups in excel

[vab323]

Hi guys I want to add the sales number if the id is equal

example: I want add 901 and 2994 if id is same in this case id is 40317

[TABLE="width: 501"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]539 8th Ave[/TD]
[TD="align: right"]40317[/TD]
[TD="align: right"]40317[/TD]
[TD]C[/TD]
[TD]N[/TD]
[TD]Y[/TD]
[TD="align: right"]901[/TD]
[/TR]
[TR]
[TD]539 8th Ave[/TD]
[TD="align: right"]40317[/TD]
[TD="align: right"]40317[/TD]
[TD]E[/TD]
[TD]N[/TD]
[TD]Y[/TD]
[TD="align: right"]2994.5[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

Does something like this help, you have 2 Columns with the ID in your Table, I used Column B:

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	539 8th Ave	40317	40317	C	N	Y	901		ID	TOTAL
2	539 8th Ave	40317	40317	E	N	Y	2994.5		40317	4117.5
3		40315					350		40315	1349
4		40317					222
5		40315					999
Sheet27

Cell Formulas
Range	Formula
J2	=SUMIF(B$1:B$5,I2,G$1:G$5)

Formula copied down.