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