Calculate quantities

[smartbim]

Hi Folks, can someone help me with this? I have three tables, 

1) Work done List

In this table, each item has ID, Code and 3 phases for each item. user will select which phase is completed through a form.

Ex.
001 | D1 | Phase 01 | Phase 02 | Phase 03
002 | FW1 | Phase 01 | Phase 02 | Phase 03

2) Material List

In this table, each item has material quantities
Ex.
001 | D1 | Material 1 | Qty
001 | D1 | Material 2 | Qty
002 | FW1 | Material 1 | Qty
002| FW1 | Material 2 | Qty
002| FW1 | Material 3 | Qty

3) Material takeoff

D1 | [Calculate Qty]
I want to calculate material quantities based on Phases in the work done list table

[AleksiAlkio]

A little bit more details are needed.
#1 - Do you need to calculate per phase (Phase 1, Phase 2, Phase 3)? Meaning.. do you have different phases like "Completed", "Not completed" etc.
#2 - Do you need to calculate per material as you have different materials (Material 1, Material 2 etc.) for example for code D1

[smartbim]

Yes correct.

Workdone List have one ID for each item. while Material List have more materials with same ID equal to Workdone List

[AleksiAlkio]

Would you please give some real samples what the results should be. Now it's still a little mystery, thanks.

[Tommy62]

Machen Sie sich mit der Funktion SUM() vertraut. Hier ist ein gelöster Thread: Formula-Problem-Auto-Sum-all-items