Hello,
I am struggling to build a formula where cell I26 will contain the sum of all subcontract amounts in rows where columns C, D, E and F are all simultaneously populated with the letter "N".
As seen in the attached image, I10:I15 contain subcontract amounts. I would like for cell I26 to only include the sum of values in rows which have the letter "N" in columns C, D, E, and F. In my screenshot, this would only apply to row 15, meaning the value in cell I26 would be $1,000, since this is the row that has marked "N" to all four criteria.
I assume this is some kind of SUMIF formula, however I am not sure how to get it to only take the sums of rows that have all four of these cells populated.
Thank you,
Bookmarks