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.