Summing cells depending on the value of the cells above.

Hi,

I am building a spreadsheet which lets me track the volume of certain metals dug up from the ground. Before a dig there is an expected volume for certain metals. Sometimes other metals appear when we begin digging. I want to be able to track the volumes of metals we dig up but I want to be able to sum them automatically. One column of the summation of the metals we expected and one summation of the metals we did not.

I have attached the spreadsheet I am using.

I imagine it is the SUMIF function I want but not sure how to code it.

In laymens terms I want in one column:
SUMIF (Only include in the sum if (In the top line your column has a value (>0??), if not you wont be included)
SUMIF (Only include in the sum if the top value of your column is 0)

Hope this makes sense.

Many thanks,

Will