Help with a formula

Hi,

I am trying to figure out how to create a formula that will give me the difference between the Awarded Green Sheet number and the Not Awarded Green Sheet Number for the subcontractors with the same trade and same project. Attached is an image of what I am looking for.

Any help is appreciated.

Thank you,
Allison Buffy

AttachmentSize
Excel.JPG271.34 KB