Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct with criterias
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. -- aac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct with criterias | Excel Discussion (Misc queries) | |||
SUMPRODUCT with 2 criterias | Excel Worksheet Functions | |||
Sum If using 2 criterias | Excel Discussion (Misc queries) | |||
Additional Sumproduct Criterias | Excel Worksheet Functions | |||
Sumif or Sumproduct 2 criterias not working | Excel Discussion (Misc queries) |