Pulling 1 of each account # from data set

Hi,
I have a bunch of data, for example;
A1: J3000
Column C has the account number which repeats multiple times.
I'm using the =SUMPRODUCT function to pull information I need in a summary table.

The problem:
I have to manually put in the account numbers in the summary table, as I only want a unique account # to come up 1X.

I would like the summary table to get the Account Number in column C then use the "=SumProduct" function to pull the data (which I can do).

How can I do that.
Thanks for your help.

Jason