combining functions

M

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
 
J

JoeU2004

Maggie said:
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 -----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top