| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add numbers in two column based on the date in another?
Hi,
This assumes your data starts in row 2. Put this in P2 and drag down =IF(B3<B2,SUMPRODUCT($N$2:O2)-SUM($P$1:P1),"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mysa" wrote: Hi Please help. Using Excel 2003, I am trying to find a way to determine if a date changes in a range, total amounts in two columns, by date, by route otherwise return a blank. A=Route# B=Date N=Total Hours(of a call) O=Time Between Calls P=Total of N+O A B N O P 01 16/02/2010 1.25 FALSE 01 16/02/2010 1.17 0.167 01 16/02/2010 0.50 0.083 01 16/02/2010 1.25 0.083 4.503 01 17/02/2010 1.00 FALSE 1.00 I tried this =SUMIF(B2:B30,"<="&B2,N2:O100) Thank you Mysa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Summing data in one column based on date in another column | Excel Programming | |||
| Adding numbers based on date | Excel Worksheet Functions | |||
| Auto Fill Column with Date based on rows in other column | Excel Programming | |||
| Add amounts in a column based on transaction date in another column | Excel Programming | |||
Threaded Mode
