How do I add numbers in two column based on the date in another?

[Mysa]

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

 

[Paul Robinson]

Hi
No idea what you want. Could you say what you expect your formula to
give you in this example?
regards
Paul

 

[Mike H]

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$11),"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.