Hi,

If you can put the results in a new column, the following formula will do
the trick

=IF(A2,"",SUMPRODUCT(--(A$2:A2<C$2:C2))-SUM(D$1:D1))

This formula assumes that column A contains the Acct# and C contains the
Linked#. It also assumes that column A is empty on the rows between each
group, you could use column B for this purpose just as well (change A2 to
B2). This also assumes you have data starting on row 2. Just copy the
formula down column D.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"DestinySky" wrote:

I am not certain that I can correctly explain what I am looking for so if
this does not make sense please let me know!! :o))

Ok I have 3 columns

Account number Account Name Linked account
123456 XYZ Customer 123456
123456 XYZ Customer 654321




The 1st column are my sold to account numbers (billing) and the linked
column are my ship to account numbers(shipping locations). What I need to do
is get the total linked account numbers, BUT I do not want to count the
account number if it is the same as what is in column 1.

I have done a subtotal to count at each change in account numbers in column
1 and 3.

Does this make sense?!?