Im sure this has been asked... I have searched a lot of threads to try and find the answer but cant seem to see what I want.

I currently have a report that exports to excel and is 900pgs long so i want a second page that is a summary.

the data comes in similar to this:

A B C D E F G H
doc number date project funded commited obligated expended net
00001 1/12/07 TRAVEL $450 $10 $40 $200 $200
00002 2/23/07 SUPPLY $100 $20 $30 $40 $10


and so on. for about 2000 lines i think.. there are 12 projects all together.

what i want to do is get a summary of each project .. I assume i need to do a vlookup array or something then sum the results.....Somehow i think I could use a macro to run each individualy for the projects that populates the summary sheet... I do know that i dont really want to use the auto filter since suming the results each time doesnt allow me to print a nice summary for my command.

Any ideas? I will post a sample soon.. but i need to download it at work later.

thanks for the ideas.