It would seem that the math is simple, but I can't figure out how to do it...
I have 5 events, each with a different cost. You pick and choose the events
you would like to attend. I need to see who is attending which events, how
much each person owes, and how many are attending each event. What equation
can I put it in the total due column so it automatically adds up. Monday is
$15, Tuesday is $5, Wed is $15, Thurs is $10, Fri is $35


Example
Name: Mon Tues Wed Thurs Fri Total $ due
John 1 1
Kate 1 1 1
Sam 1 1 1

# attend 2 1 3 1 1

--
Maggie