| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif on pulling out data from dates
I have a data rage that column A is employee name, column B is date that the
employee worked, and Column C is the hours worked on that day. Their are additional columns that calulate overtime. On a separate Sheet i have an overveiw of this and other data. I want to do a sumif that will pull all of the hours from a given month and total them up on the overview page. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif on pulling out data from dates
One way...
To sum hours for Jan 2008: =SUMPRODUCT(--(TEXT(Sheet1!B2:B20,"mmm/yyyy")="Jan/2008"),Sheet1!C2:C20) -- Biff Microsoft Excel MVP "Eagleryder" wrote in message ... I have a data rage that column A is employee name, column B is date that the employee worked, and Column C is the hours worked on that day. Their are additional columns that calulate overtime. On a separate Sheet i have an overveiw of this and other data. I want to do a sumif that will pull all of the hours from a given month and total them up on the overview page. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif on pulling out data from dates
Thank you it worked like a charm.
"T. Valko" wrote: One way... To sum hours for Jan 2008: =SUMPRODUCT(--(TEXT(Sheet1!B2:B20,"mmm/yyyy")="Jan/2008"),Sheet1!C2:C20) -- Biff Microsoft Excel MVP "Eagleryder" wrote in message ... I have a data rage that column A is employee name, column B is date that the employee worked, and Column C is the hours worked on that day. Their are additional columns that calulate overtime. On a separate Sheet i have an overveiw of this and other data. I want to do a sumif that will pull all of the hours from a given month and total them up on the overview page. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif on pulling out data from dates
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Eagleryder" wrote in message ... Thank you it worked like a charm. "T. Valko" wrote: One way... To sum hours for Jan 2008: =SUMPRODUCT(--(TEXT(Sheet1!B2:B20,"mmm/yyyy")="Jan/2008"),Sheet1!C2:C20) -- Biff Microsoft Excel MVP "Eagleryder" wrote in message ... I have a data rage that column A is employee name, column B is date that the employee worked, and Column C is the hours worked on that day. Their are additional columns that calulate overtime. On a separate Sheet i have an overveiw of this and other data. I want to do a sumif that will pull all of the hours from a given month and total them up on the overview page. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data by start/finish dates | Excel Discussion (Misc queries) | |||
| Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions | |||
| Sumproduct - Pulling info based on lenght of time between dates | Excel Worksheet Functions | |||
| pulling back dates that meet certain criteria | Excel Worksheet Functions | |||
| Sum of data between two dates - tried SUMIF and it returned "0" | Excel Worksheet Functions | |||
Hybrid Mode
