You could have a simple script count the weights on each line and set a field value with the total.