I have a lot of temps that work for me. Most of the time some of my temps
work for me every day, however, my temp force does change daily. I need a
formula that will total each temps hours for the week. It has to be on a
single worksheet since I have to turn submit it for verification.
Here's what I have:

A B D E G H J K
M N P Q
8/24/09 8/25/09 8/26/09 8/27/09 8/28/09 8/29/09
Jack 4 Craig 8 John 4 Jack 7 Debbie 9
Arnetta 6
Joe 6 Greg 8 Aaron 4 Joe 7 Jennifer 9 Joe 6
Bill 8 Les 8 Jason 4 Bill 5 Julie 9 Kelly
7
Sue 5 Chaz 8 Mike 4 Sue 3 Venus 9 Sue 7
Les 7 Melissa 8 Mark 4 Les 7 Agnes 9 Meliss 6
Sam 5 Bill 8 Jack 6 Sam 5 Brian 10 Sam
6
Arnetta 5 John 8 Joe 4 Arnetta 8 Bradley 10 Jack
6
Chaz 8 Aaron 8 Bill 4 Chaz 8 Curt 8 Chaz 6
Melissa 8 Jason 8 Sue 4 Doug
10 Les 7
Kelly 8 Mike 8 Les 6
Austin 8 Bill 7
John 8 Mark 8 Greg 4 Bill 8
John 7

Tina 10

Tanner 8 JT 8 PJ 8

I need: Column A will list each employee that worked during the week.
Column B needs to be the total hours worked by the employee listed in
Column A.

A B
Week Ending 8/29/09
Jack 23 (B2+H7+K2+Q8)
Joe 23 (B3+H8+K3+Q35)
Bill 40 (B4+E7+H9+K4+N12+Q11)
Sue
Les
Sam
Arnetta
Chaz
Melissa
Kelly
John
Craig
Greg
Aaron
Jason
Mike
Mark
Debbie
Jennifer
Julie
Venus
Agnes
Brian
Bradley
Curt
Doug
Austin
Tina
Tanner
JT
PJ
Total 86

I can't seem to get it. Not sure if I'm making it more difficult than it
really is or what, but I definitely need some help.

Thanks so much.