Price per person for activities

[crangirl]

Hello,

I haven't been able to find how to do this (or hów to find this on a forum.. because I don't know what to call the problem/function..
I guess it's not that hard, I hope someone can help me.
(I'm at work alone now and need to do this; I'm a volunteer here, it's an organization for people with disabilities so I'm not a trained employee and didn't study Excel.. just did a course from Youtube (Excelisfun) and found this site/forum).

So..:
I have an Excel file with people who registered for multiple activities..
(row 1: activities; row 2: cost per activity
column 1: last name; columns: If a person subscribed, I've put the date of registration in the cell.. for each activity (sometimes the activities are full, so
the date is important).
I hope you can follow me this far..

But now I want to know how much each person (about 200 of them) need to pay.. I could do this by hand.. but I'd rather use Excel (and all the hours I've put in the file). It's Excel 2003 (Dutch).
So for example:

Activity:----A------------B------C--------------D--------E
Costs: -----2 -----------5------ 10 -------------4 ------25
person 1: 1-may -----(empty) --1-may -------1-may --(empty)
person 2: --(empty)---5-may ---5-may--------(empty) -- 5-may


Is it possible to lookup/search for the costs in the second row..IF there is a date (and not for the activities they don't want).
Is there a formula I can use (Lookup/IF?) or a combination of formulas?
Should be: person 1 = 2+10+4

I hope you know what I mean..
otherwise I'll be adding the costs per person by hand/looking them up in Excel per person (SUM) and I think this should be less time consuming.

Thank you in advance!

 

[crangirl]

Uh.. redfont seems to work (?),now I have to get the formula right..

 

[crangirl]

Uh.. redfont seems to work (?),now I have to get the formula right..

=SOMPRODUCT(--(NIET(redfont(H3:W3))*$H$2:$W$2*--(ISGETAL(I3:X3))))

seems to work, but the costst aren't correct.. .. Will keep trying..

 

[crangirl]

Seems to work now, (made a mistake in the formula), thank you!

 

[GlennUK]

Oh good. Glad to help!