I havre attached a file with my sheet. I am trying to figure the discount on the invoice where the customer has already paid for 80% of the material. The customer wants the bid price for material on each invoice, but show the 80% already paid on 1 line at the bottom. I have tried to work this with an array formula, which you can find in cell, L89. The reason for wanting to exclude lines with $ 0.42, is that the customer did not pay for 80% of that item.
Please email of you need further info.

-ken