Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have several columns that I need to summarize data that meet certain
criteria. The idea is to summarize labor hours by Job Number by Date. Example of Data: Col 1 Col 2 Col 3 Col 4 Job # Employee Name WE Date # Hours Job1 Don Duck 10/27/06 14 Job2 Mike Mouse 9/29/06 40 Job3 Joe Blow 11/3/06 16 Job1 Tom Terrific 9/22/06 36 Job1 Sylvester Katz 8/26/06 20 Job2 Don Duck 10/27/06 26 Example of Desired output: Aug 06 Sep 06 Oct 06 Nov 06 Job1 xx Hrs xx Hrs xx Hrs xx Hrs Job2 xx Hrs xx Hrs xx Hrs xx Hrs Job3 xx Hrs xx Hrs xx Hrs xx Hrs I want to set parameters such that if the hours worked fall between the beginning of a month and the end of that same month they are summed in that month column. My example is, of course, a much simplified version of a data base with some 13 thousand lines. Any suggestions will be appreciated. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |