| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Information
I have created a workflow to determine work hours from when a request was
received until it is completed. The date / time is captured as yyyy/mm/dd hh:mm In the workflow the date / time is captured in column A while the type off request (open account) is captured in column F. I am now creating a summary in a new worksheet of how many requests of which type were received on a spesific date (yyyy/mm/dd) The date is shown in column A in the new worksheet while the request type will be captured in row 1 Column A Column B Row 1 Open Account Row 2 2008/08/01 #?? Thank you! -- Andrew |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating Information
If your workflow data is on Sheet1 (columns A and F)Perhaps:
=SUMPRODUCT(--(INT(Sheet1!$A$2:$A$5)=$A2), --(Sheet1!$F$2:$F$5=B$1)) "Andrew" wrote: I have created a workflow to determine work hours from when a request was received until it is completed. The date / time is captured as yyyy/mm/dd hh:mm In the workflow the date / time is captured in column A while the type off request (open account) is captured in column F. I am now creating a summary in a new worksheet of how many requests of which type were received on a spesific date (yyyy/mm/dd) The date is shown in column A in the new worksheet while the request type will be captured in row 1 Column A Column B Row 1 Open Account Row 2 2008/08/01 #?? Thank you! -- Andrew |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating Information
Thank You 100%!!!!
-- Andrew "Andrew" wrote: I have created a workflow to determine work hours from when a request was received until it is completed. The date / time is captured as yyyy/mm/dd hh:mm In the workflow the date / time is captured in column A while the type off request (open account) is captured in column F. I am now creating a summary in a new worksheet of how many requests of which type were received on a spesific date (yyyy/mm/dd) The date is shown in column A in the new worksheet while the request type will be captured in row 1 Column A Column B Row 1 Open Account Row 2 2008/08/01 #?? Thank you! -- Andrew |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating Information
you're welcome. thanks for the feedback.
"Andrew" wrote: Thank You 100%!!!! -- Andrew "Andrew" wrote: I have created a workflow to determine work hours from when a request was received until it is completed. The date / time is captured as yyyy/mm/dd hh:mm In the workflow the date / time is captured in column A while the type off request (open account) is captured in column F. I am now creating a summary in a new worksheet of how many requests of which type were received on a spesific date (yyyy/mm/dd) The date is shown in column A in the new worksheet while the request type will be captured in row 1 Column A Column B Row 1 Open Account Row 2 2008/08/01 #?? Thank you! -- Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| information | Excel Discussion (Misc queries) | |||
| LOOK UP INFORMATION | Excel Worksheet Functions | |||
| Name Box Information | Excel Discussion (Misc queries) | |||
| Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Linear Mode
