nested conditional query

[RayB]

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.

 

[FiluDlidu]

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...

 

[Bernie Deitrick]

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]

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