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.