#### scubafrog79

##### Programmer

Then further down in the spreadsheet I have 12 columns with data in two rows.

In this example my value in cell B2 would now be 800,000 since I'm subtracting 200,000 from 1,000,00. However, I want the formula to sum the first row where ever there is a "NO" on the second, there could none or one or multiple on the second.