I have several columns with numerical values; A, B, C, D, and E, with column
F being a total of the row.
At the bottom of each column is a "Yes", "No" validation. Column A, C, and
E have been validated to "Yes".
How do I get, say, cell G1 to see if the Validation for the Column is "Yes"
then subtract the row value in that column from the total in column F?

Columns A, B, C, D, E = Ordered from each sales person
Columns F = Total items ordered
Yes, No validation = Items delivered
Column G = total items YET to be delivered
(A column is completely delivered at one time)

Thanks!