sumproduct with criterias

A

aac

Here is a small sample of my sheet ("Main") where details of clients are
added on a daily bases.
Sheet2 is a summary sheet with hours breakdown.

A B D E
Date Client Hours Total
hours(cumulative)
5-Sep-07 A 5:20 5:20
7-Sep-07 B 5:15 10:35
8-Sep-07 A 10:05 20:40
9-Sep-07 B 0:35 21:15
9-Sep-07 B 7:40 28:55
9-Sep-07 A 0:15 29:10
and so on.....

I need a code to extract hours (between two dates) under 21 hours and over
21 hours for each client. Below gives an example of the lay out in sheet 2.

Sheet2: Summary sheet.
cell P3: Date from
cell R3: Date to
cell H9: Client "A" hours under 21:00 = 15:25 hours
cell N9: Client "B" hours under 21:00 = 5:35 hours
cell H11: Client "A" hours over 21:00 = 0:15 hours
cell N11: Client "B" hours over 21:00 = 7:55 hours


Thank you.
 

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