Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default SUMPRODUCT

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding "OR" to a Sumproduct Formula Duke Carey Excel Worksheet Functions 0 March 21st 06 06:41 PM
Need help with sumproduct and dynamic ranges Bill_S Excel Worksheet Functions 2 March 19th 06 01:19 AM
Sumproduct Peter B Excel Worksheet Functions 1 March 7th 05 01:59 PM
Sumproduct function not working Scott Summerlin Excel Worksheet Functions 12 December 4th 04 05:15 AM
adding two sumproduct formulas together ski2004_2005 Excel Worksheet Functions 1 November 12th 04 09:08 PM


All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"