Untitled.jpg

ok so there's a screen grab of my excel document what I need to do is the total at the bottom of the name column to deduct the value of each way of the drop down list is put on paid or is there a better way I need to manage the drop down box to achieve this if that make any sense.

any help would be great thank you.