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

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

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

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