MS Excel - Advanced VLOOKUP

[Shadowmaster02]

I have a spreadsheet with many thousand rows of data and am trying to lookup and sum amounts from the table but am not sure the best way to do it. In the first row of the table there is an account number and then there is the activity for the account. For each account number there could be many thousands of entries. I want to lookup the account number in the table and for all entries that match the account number I need to sum up the activity. Here is what the table looks like:

Acct # Amount
1 10
1 15
2 20
2 5

I want to be able to lookup all entries with account number 1 and get the sum of the amounts, in this example it would be 25.

Any help would be greatly appreciated! Thanks.

 

[Shadowmaster02]

Nevermind. I was able to get a Pivot table to do the job.

 

[Jagercola]

Praise the almighty pivot table...

 

[Fingolfin269]

Originally posted by: Shadowmaster02
Nevermind. I was able to get a Pivot table to do the job.

Yup, was going to be my suggestion. That function works wonders.