Excel timetable creation

  • Thread starter Thread starter Kate
  • Start date Start date
K

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?
 
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..
 
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





.
Click to expand...
 
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..
 
Back
Top