Lookup and Sum

[Neflheim]

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.

[StephenR]

Pivot tables are your friends...

[Neflheim]

wow.. hey man thanks.. I am going to play with those....thats a function i didnt know about..

thanks again

[japper]

For summaries, if you don't get to grips with (or don't like) Pivot tables, then SUMIF is a handy function.

eg SUMIF(c:c,"TRAVEL",d:d)
This will add up the numbers in column d if TRAVEL appears in column c.

Hope this helps

[Neflheim]

oh man.. thanks.. didnt think of that one.. i knew there was something to do this easier then a vlookup thing..

THanks man!