You might consider importing them into a table in an Access database, then you can run all your queries against the entire dataset without the need for arrays and massaging, you'll be able to create any manor of summation. Excel has built-in tools to pull data from Access.