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

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

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

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