combining functions

[Maggie]

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

 

[Don Guillett]

One way
where you put the amount in row 1
=($B$1*B3)+($C$1*C3)+etc

 

[JoeU2004]

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

One way:

=SUMPRODUCT(B2:F2, {15,5,15,10,35})

assuming that John's Mon-Fri data is in B2:F2. You can copy the formula
down for the other attendees and for the "# attend".

But it would be easier to maintain (change) if the Mon-Fri rates were in a
table, say V1:Z1. Then you could write:

=SUMPRODUCT(B2:F2,$V$1:$Z$1)


----- original message -----