Prev: Call Stack Available ?
Next: Modeless User Form Is Blank
From: Mysa on 10 Mar 2010 09:45
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
From: Mike H on 10 Mar 2010 10:04
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
From: Paul Robinson on 10 Mar 2010 10:02
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 <M...(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: Call Stack Available ?
Next: Modeless User Form Is Blank