Excel timetable creation

[Kate]

I am trying to create an excel timetable that doubles as
a time sheet. What I want to do is total all my classes
in hours. Each cell has a class name and is in a time
slot. What I want to do is, if there is a class name in
a cell I want it to total up as a number in the total
column. Is there a formul that I can use to acheive that?

 

[Peo Sjoblom]

One possible way

=SUMPRODUCT(LOOKUP(A2:A10,{"a";"b";"c";"d";"e"},{10;20;30;40;50}))

where a, b and so on should be replaced by the class names and 10, 20 and
so on by
their time equivalent and A2:A10 holds the classes you have done..

 

[Kate]

I gave it a go but no luck

-----Original Message-----
One possible way

=SUMPRODUCT(LOOKUP(A2:A10,{"a";"b";"c";"d";"e"}, {10;20;30;40;50}))

where a, b and so on should be replaced by the class names and 10, 20 and
so on by
their time equivalent and A2:A10 holds the classes you have done..

--

Regards,

Peo Sjoblom





.

 

[Peo Sjoblom]

I think you have to describe your problem a little bit more
in depth.. How do you retrieve your information, what are your ranges,
what do you expect to get and so on? Give us an example..