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

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

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