Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct help
First part of this question and answer can be found by searching: ""rEPOST:
Summing clock in and out by date"" Okay, here is another one for you. The last solution you gave me worked perfectly. On the same sheet as the production hours: Week Ending: Total Production Hours January 15, 2006 8 January 08, 2006 12 January 01, 2006 12 December 25, 2005 5 December 18, 2005 12 I would like to ask for help to come up with a total count (weekending): Week ending: January 15, 2006 Status of Contacts # EC - All 2 EC - Analog Only 3 EC - Dig Only 3 EC - Dig and HIS 0 EC - Dig and Phone 0 EC - HSI Only 0 EC - HSI and Phone 0 EC - Phone Only 0 EC - Other 0 of all inputted data from the from the following: EC - EC - EC - All Analog Only Dig Only 1/1/2006 1/2/2006 1 2 3 1/3/2006 3 1 2 1/4/2006 2 3 1 1/5/2006 1 2 3 1/6/2006 3 1 2 1/7/2006 2 3 1 1/8/2006 1 2 3 1/9/2006 3 1 2 1/10/2006 2 3 1 1/11/2006 1 2 3 1/12/2006 3 1 2 1/13/2006 2 3 1 1/14/2006 1 2 3 1/15/2006 3 1 2 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct help
Why start a new thread when you have continued this in the other thread. I
believe Roger has answered it? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jim" wrote in message ... First part of this question and answer can be found by searching: ""rEPOST: Summing clock in and out by date"" Okay, here is another one for you. The last solution you gave me worked perfectly. On the same sheet as the production hours: Week Ending: Total Production Hours January 15, 2006 8 January 08, 2006 12 January 01, 2006 12 December 25, 2005 5 December 18, 2005 12 I would like to ask for help to come up with a total count (weekending): Week ending: January 15, 2006 Status of Contacts # EC - All 2 EC - Analog Only 3 EC - Dig Only 3 EC - Dig and HIS 0 EC - Dig and Phone 0 EC - HSI Only 0 EC - HSI and Phone 0 EC - Phone Only 0 EC - Other 0 of all inputted data from the from the following: EC - EC - EC - All Analog Only Dig Only 1/1/2006 1/2/2006 1 2 3 1/3/2006 3 1 2 1/4/2006 2 3 1 1/5/2006 1 2 3 1/6/2006 3 1 2 1/7/2006 2 3 1 1/8/2006 1 2 3 1/9/2006 3 1 2 1/10/2006 2 3 1 1/11/2006 1 2 3 1/12/2006 3 1 2 1/13/2006 2 3 1 1/14/2006 1 2 3 1/15/2006 3 1 2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct help
Bob,
In addition to others you have helped me often in the past. I have found the communities to be a priceless, valuable tool. It is not my intent to upset the system or process, however more often than not when I respond to an existing thread I do not receive an answer. Or, sometimes I receive answers that are not helpful at all. So having posted a question once and having received an answer that was not helpful I have assumed that other community readers would not view my posting because it was already answered (an example is an answer I received from my last posting, the person answering offered more of a commentary than a solution). If there is indeed a different way to receive an answer than reposting please let me know I am happy to follow your suggestion. Roger did indeed answer my questions, so perhaps I was not patient enough. Respectfully Jim "Bob Phillips" wrote: Why start a new thread when you have continued this in the other thread. I believe Roger has answered it? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jim" wrote in message ... First part of this question and answer can be found by searching: ""rEPOST: Summing clock in and out by date"" Okay, here is another one for you. The last solution you gave me worked perfectly. On the same sheet as the production hours: Week Ending: Total Production Hours January 15, 2006 8 January 08, 2006 12 January 01, 2006 12 December 25, 2005 5 December 18, 2005 12 I would like to ask for help to come up with a total count (weekending): Week ending: January 15, 2006 Status of Contacts # EC - All 2 EC - Analog Only 3 EC - Dig Only 3 EC - Dig and HIS 0 EC - Dig and Phone 0 EC - HSI Only 0 EC - HSI and Phone 0 EC - Phone Only 0 EC - Other 0 of all inputted data from the from the following: EC - EC - EC - All Analog Only Dig Only 1/1/2006 1/2/2006 1 2 3 1/3/2006 3 1 2 1/4/2006 2 3 1 1/5/2006 1 2 3 1/6/2006 3 1 2 1/7/2006 2 3 1 1/8/2006 1 2 3 1/9/2006 3 1 2 1/10/2006 2 3 1 1/11/2006 1 2 3 1/12/2006 3 1 2 1/13/2006 2 3 1 1/14/2006 1 2 3 1/15/2006 3 1 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |