Filter and Sum Similar Items

[helpexcel]

I have a spreadsheet with data in columns A:L. All of the data is the same expect for columns H & L. Is there a macro (vlookup and sumproduct take to long to calc) I can use that would basically take the 1st entry and and copy it to a new sheet with the value in column L the sum of all the rows that have the same data in columns A:K (excluding Column H which is irrelevant)?

A	B	C	D	E	F	G	H	I	J	K	L
Orange	ABC	DEF	GHI	JKL	MNO	PQR	California	STU	VWX	YZ	100
Orange	ABC	DEF	GHI	JKL	MNO	PQR	Florida	STU	VWX	YZ	150
Orange	ABC	DEF	GHI	JKL	MNO	PQR		STU	VWX	YZ	250

<colgroup><col><col><col><col><col><col><col span="6"></colgroup><tbody>
</tbody>

 

[arthurbr]

Have you tried a Pivot Table or Power Pivot ?

 

[helpexcel]

A pivot table will count an item as many times as it appears in the list. I only want it counted once, even if it appears 100 times.