| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add numbers in two column based on the date in another?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I add numbers in two column based on the date in another?
Hi
No idea what you want. Could you say what you expect your formula to give you in this example? regards Paul On Mar 10, 2:45*pm, 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 |
|
#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 |
| Reply |
| 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 | |||
Hybrid Mode
