Thread: Plz help.. When a prodhiernr changes i want to sum the costs for this product.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wayne Wayne is offline
external usenet poster
  
Posts: 133
Default Plz help.. When a prodhiernr changes i want to sum the costs for t
Jack,

You could use the Subtotal function -- under the Data menu,.....

wAyne_

"JackSchilder" wrote:


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=512702


Reply With QuoteReply With Quote