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
"JackSchilder" wrote:
I also posted this on excel programming :) im desperate for a reply.
Hi there,
so i have for example :
prodhiernr artnr cost
1110050 123456 50
1110050 123544 60
1110050 234343 70
1110051 534222 90
1110051 353533 100
1110051 124643 80
When de prodhiernr changes to 1110051 i want to sum the total cost for
prodhiernr 1110050 and later on for the other products also (the list
is very long).. Does anyone have a clue how to do this?
Thanks in advance
--
JackSchilder
------------------------------------------------------------------------
JackSchilder's Profile: http://www.excelforum.com/member.php...o&userid=31577
View this thread: http://www.excelforum.com/showthread...hreadid=512705