View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul
 
Posts: n/a
Default find a value in a table, go to the previous column and add that co

Hello I hope you can help

I have a monthly roster that looks like this
A....B......C.........D.........E...........F..... .....G
1................................ Mon.....Tues....Wed......
2..start..finish...HRS...3 Apr.....4 Apr...5 Apr.....
3..7:00..15:00..7:30.............................. ..........
4..7:00..15:30..8:00...TRICIA...SUE....THERESE
5..7:00..15:30..8:00.............................. ...........
6..7:30..13:00..5:00...JEANNE..ANNA...FIONA
8..7:30..16:00..8:00.................CHRIS........ ......

I would like to total the hours for each day. Hours are in cell D3:D8. So
monday would equal 13, tues 21 etc.
Is there a formula that I can place in the cell which will add the days
hours together?

Your help is greatly appreciated