something like this?
=sumproduct((a2:a22=123456)*(c2:c22<123456))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DestinySky" wrote in message
...
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?!?