Formula For Quantity of Paint on Invoice

Hello,

I have listed the paints need for the job in the Invoice Template sheet Descriptions. Some of the paints are needed for different applications (see Spread Rates & Cost sheet).

The Material sheet lists the quantities for each application.

How can each paint color / type quantity be determined with formulas on the Invoice Template sheet?

Thank you