I am trying to find the revenue generated by different groups of accounts to figure out which group is worth the most, and rank the others.

Here is a attached screenshot of what I am working with, cell BK22 is the revenue of all of the accounts coded AADA but i need to find an easier way other than plugging it in for all 3500 cells.

Thanks.

Screen Shot 2014-01-03 at 8.57.55 AM.jpg