Lookup help

Hi all,

I am trying to create a spreadsheet for project budget tracking, the sheet has two tabs. One tab I will record each order, which will be for items such as design, material, transport, labour, etc.

The sheet will essentially look like this:

Design �1000
Material �2500
Material �3000
Design �1000

But on the summary tab, I want to collate all those costs to pull through and look like this:

Design �2000
Material �5500

I have tried to use VLOOKUP to do this, however this only picks up the first "design" or "material" line that it finds and pulls that cost through of that line rather than summing up all the design lines and all the material lines etc.

If anyone can help it would be appreciated as it's driving me insane!

Thanks

Tom

sumif()
will be a better solution

A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.


The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

=SUMIF('Project Summary'!$A$13:$A$40,'Project Summary'!A13,'Project Invoice List'!$D$10:$D$40)

i have used upto row 40 - but can extend

and assuming column D to sum, as thats what is being used in your lookup

fomula picked up wrong sheet
=SUMIF('Project Invoice List'!$A$10:$A$40,'Project Summary'!A13,'Project Invoice List'!$D$10:$D$40)

i prefer to use specified ranges rather than whole columns as that can slow things down - evaluating millions of rows - depending on excel version