Seperate sheets summarised per project on main costs sheet

Hi,

NooB here.

We are building a house and a wall at the same time (we are not building it , but we are buying the material ourselves) and would like to keep a spreadsheet to keep track of the expenses from the different companies and different projects (Wall or House)

The workbook consists of the following

- Total Costs
- Supplier A
- Supplier B
- ..
- Supplier Z

Each Supplier sheet has the same layout (basic info)

date description Pieces Price Per Item Total Price Deposit paid Still to pay PAID(Y/N) Project

2 entries for example Supplier A look like

19/2 Blocks 1000 0,5 500 0 0 Y WALL
19/2 Blocks 1000 0,5 500 0 0 Y HOUSE

Some entries for example Supplier B look like

19/2 Cable 100 1 100 0 0 Y HOUSE
19/2 Plugs 10 1 10 0 0 Y HOUSE
19/2 Cable 50 0,25 12,5 0 0 Y WALL

Now my question, I would like to have on my "Total COST" sheet a summary how much I already have paid for either WALL or HOUSE for each Supplier individual and in total.

So using the examples, in the Total Costs Sheet it should look something like this.

Supplier A Wall 500
Supplier A House 500

Supplier B Wall 12,5
Supplier B House 110

Total Wall 512,50
Total House 610,-

Any pointers are really appreciated.

Thx.

Here the book, I hope this is enough info

Edit: I am not allowed to upload it

Try again