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

  • Thread starter Thread starter Mysa
  • Start date Start date
M

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
 
Hi
No idea what you want. Could you say what you expect your formula to
give you in this example?
regards
Paul
 
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.
 
Back
Top