Counting and IF/AND criteria

[mandalores]

Hello!

I would like a certain count with different criteria which I can't figure out how to do.
I have a large document with lots of parts and I want to keep track of progress.

So, the criteria that I want is:

If Part Type (B) = Part & Finished Date (E) = "Non blank"
count Number of assemblies(C)*Number of Units(D) for this row,

and add all of those together. Then I would like to see how much that is out of the total
parts (which are the same but without the "Non blank" critera).

So as you can see in my file, I want it to find this: (2*2+1*5) / (2*2+1*5+3*1) = 9/12 = 75%

Does anyone know how to do this? Thanks for the help.

[Special-K]

Finished parts
=SUMPRODUCT((B2:B6="Part")*(E2:IE6<>"")*(D2:D6)*(C2:C6))

Total Parts
=SUMPRODUCT((B2:B6="Part")*(D2:D6)*(C2:C6))