nested conditional query
 

i have some work that i'm trying to sort and then subtotal like info.
Column A Column B Column C
acct # $$ subtotal

what happens is that i get a check with 100 accounts, some duplicates
randomly on a list. I put that into Excel and sort column A which groups like
accounts.
What i'm looking for is this. If I have 4 accounts say row 2,3,4,5 -i'd like
C2 to say..if A2 does not equal A3 then B2 else $0.00.
But how do i tell it to check A4,A5,A6 ... I really just want a subtotal on
C5 line.
I hope that makes sense. Thank You!
Ray Brewer.

nested conditional query
 

Hi Ray,

It seems to me like C3 would in its turn look for A3 and A4, find out they
are the same and return $0.00, wouldn't it?

Then C4 would again fail to find a difference between A4 and A5, therefore
returning $0.00.

And C5 would finally find that A5 and A6 are different and return the value
of B5.

I'm sure I misunderstood something, but please light my lantern...

"RayB" wrote:

i have some work that i'm trying to sort and then subtotal like info.
Column A Column B Column C
acct # $$ subtotal

what happens is that i get a check with 100 accounts, some duplicates
randomly on a list. I put that into Excel and sort column A which groups like
accounts.
What i'm looking for is this. If I have 4 accounts say row 2,3,4,5 -i'd like
C2 to say..if A2 does not equal A3 then B2 else $0.00.
But how do i tell it to check A4,A5,A6 ... I really just want a subtotal on
C5 line.
I hope that makes sense. Thank You!
Ray Brewer.

nested conditional query
 

In C2, enter the formula

=IF(A2<A3,SUM($B$2:B2)-SUM($C$1:C1),"")

and copy down, or use Excel's SUBTOTAL functionality: Data / Subtotals... subtotal on changes in
column A, summing column B.

HTH,
Bernie
MS Excel MVP


"RayB" wrote in message
...
i have some work that i'm trying to sort and then subtotal like info.
Column A Column B Column C
acct # $$ subtotal

what happens is that i get a check with 100 accounts, some duplicates
randomly on a list. I put that into Excel and sort column A which groups like
accounts.
What i'm looking for is this. If I have 4 accounts say row 2,3,4,5 -i'd like
C2 to say..if A2 does not equal A3 then B2 else $0.00.
But how do i tell it to check A4,A5,A6 ... I really just want a subtotal on
C5 line.
I hope that makes sense. Thank You!
Ray Brewer.

nested conditional query
 

THANK U. It works perfectly..i dunno how but i sure appreciate it!

"RayB" wrote:

i have some work that i'm trying to sort and then subtotal like info.
Column A Column B Column C
acct # $$ subtotal

what happens is that i get a check with 100 accounts, some duplicates
randomly on a list. I put that into Excel and sort column A which groups like
accounts.
What i'm looking for is this. If I have 4 accounts say row 2,3,4,5 -i'd like
C2 to say..if A2 does not equal A3 then B2 else $0.00.
But how do i tell it to check A4,A5,A6 ... I really just want a subtotal on
C5 line.
I hope that makes sense. Thank You!
Ray Brewer.