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

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
 
P

Paul Robinson

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

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$1:p1),"")
--
Mike

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top