Calculating Information

A

Andrew

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!
 
J

JMB

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top