Thanks for the quick reply.

I actually was looking for a formula to run in a column next to it.

Gizmo63 Wrote:
If this is just a data dump then the easiest way is to use the sub
total
function.

Highlight the data including the headers, select Data Subtotals

At each change in : prodhiernr
Use function: Sum
Add subtotal to: [check the cost box]

Click OK

If you want a formula to run in a column next to your data then post up
and
we'll try to resolve it.

hth
Giz

"[/color]


--
JackSchilder
------------------------------------------------------------------------
JackSchilder's Profile: http://www.excelforum.com/member.php...o&userid=31577
View this thread: http://www.excelforum.com/showthread...hreadid=512705