Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif
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" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif
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!! "Shane Devenshire" wrote: 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" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |