nested conditional subtotals
 

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

I get a check with one amount that applies to over 100 accounts with some
duplicates. The accounts are listed randomly on a list. I need to sort out
the account numbers and apply payments. So I am putting the account numbers
and $$ into a spreadsheet, then sorting 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 subtotals
 

If I understood the question....in C2 try entering the following.

=IF(COUNTIF(A:A,A2)1,0,B2)

Does that help?


"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

I get a check with one amount that applies to over 100 accounts with some
duplicates. The accounts are listed randomly on a list. I need to sort
out
the account numbers and apply payments. So I am putting the account
numbers
and $$ into a spreadsheet, then sorting 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 subtotals
 

Ray,

Please don't multi-post (post the same question multiple times to different groups) - it is OK to
Cross-post (Select multiple groups at the same time, but with a single post) - it just duplicates
efforts.

My reply in the Misc group...
**************************************
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

I get a check with one amount that applies to over 100 accounts with some
duplicates. The accounts are listed randomly on a list. I need to sort out
the account numbers and apply payments. So I am putting the account numbers
and $$ into a spreadsheet, then sorting 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.