sumif

[TLR]

Hi,

I have a schedule set up by week for the whole year on one sheet going down.
For example:

Week 1 Sunday Monday Tuesday etc....
Tom Mary Tom
Jane

Week 2 Sunday Monday etc...
Jane Tom
Jim
Week 3 Sunday Monday
Robert Tom

Within each day there's a possibility of 6 people working, 3 in the AM and 3
in the PM, out of a list of 13. Per line, I have time in and out and total
hours. I need to find across all seven days how many times "Tom" worked and
total all of the hours. He can appear on different lines and days.

I hope this makes sense. I can share the file if you need to see it.

 

[Shane Devenshire]

Hi,

Try =COUNTIF(range,"Tom")
and you didn't show us where the times were or how they are stored so
=SUMIF(range,"Tom",HoursRange)

If this helps, please click the Yes button

cheers,
Shane Devenshire

 

[TLR]

Hiya,

Sorry I left out some information.... i guess it really is a little more
complicated. Here are Sunday and Monday of one week, after monday it
continues, Tuesday, Wed... etc. I need to find all of the days (from
Sun-Sat) Tom worked and then add up all of the hours he worked. So that if he
worked more than, let's say, 24 hours it needs to be counted as overtime. As
you can see, there are a lot of columns, and they're separated in sections,
by day. So Sunday is one box, Monday is another box.... I wanted to make
this summary by the week, in the sheet itself, to the right of the last day
of the week, saturday.... (nothing else fits to the right in this web
form... sorry!)

Week 1
Sunday
Monday
IN OUT HRS
IN OUT HRS
AM Tom 7:00AM 7:00PM 12.00 Robert 7:00 7:00
12.00
Jane 7:00AM 7:00PM 12.00 Jim 7:00
7:00 12.00
Jim 7:00AM 7:00PM 12.00

PM Tom (OT) 7:15PM 7:00AM 11.75 Tom(OT) 7:00 7:00
12.00
Mary 7:00PM 7:00AM 12.00 Jane 7:00
7:00 12.00


Thanks!!