IF/Then formula assistance

[DTbox]

I'm trying to do the following. I've searched on line and hae come up empty with results. Maybe I'm not using the correct terminology, hopefully I can get some assistance here. Thanks in advance for taking the time to help.

I have cells in column D as a drop down so the user can select YES/NO if they are done with that section of the document. I'd like the YES/NO row of each major heading to auto populate with YES/NO based on whether all of the subsections are completed, YES.

For instance, look at column A (Para. No.), specifically "1". I'd like D3 to auto populate with YES if both the sub sections (1.1 and 1.2) are YES, and vise verse, say NO if any subsection says NO. What is the formula I would enter into D3? I'd then copy that formula for each of the other sections.

 

[Mr Kulle]

=IF(AND(D4="YES",D5="YES"),"YES","NO")

No copy because all your projects have different qty of rows
Do it manual :")
D6 will look something like this

=IF(AND(D7="YES",D8="YES",D9="YES",D10="YES"),"YES","NO")

 

[Fluff]

Another option

=IF(COUNTIFS(D7:D10,"No"),"No",IF(COUNTIFS(D7:D10,"<>"),"Yes",""))

 

[DTbox]

Thansk!

=IF(AND(D4="YES",D5="YES"),"YES","NO")

No copy because all your projects have different qty of rows
Do it manual :")
D6 will look something like this

=IF(AND(D7="YES",D8="YES",D9="YES",D10="YES"),"YES","NO")

 

[DTbox]

Another option

=IF(COUNTIFS(D7:D10,"No"),"No",IF(COUNTIFS(D7:D10,"<>"),"Yes",""))

Worked perfectly, thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[DTbox]

Sorry, one last question. How do I add another part to the formula?

The below works great and now I need to add another drop down, IN PROGRESS.
=IF(COUNTIFS(D7:D10,"No"),"No",IF(COUNTIFS(D7:D10,"<>"),"Yes",""))

What changes to the formula if I need the following to occur?

D3 only needs to display YES or NO.

If the group below is not all YES, then D3 displays NO. For instance, if D4 is YES and D5 is IN PROGRESS, then D4 is NO. D3 is only to display a YES is all cells in that section reflect a YES in the cell.

Glad we could help & thanks for the feedback

 

[Fluff]

How about

=IF(COUNTIFS(D7:D10,"<>Yes",D7:D10,"<>"),"No",IF(COUNTIFS(D7:D10,"<>"),"Yes",""))

 

[DTbox]

How about

=IF(COUNTIFS(D7:D10,"<>Yes",D7:D10,"<>"),"No",IF(COUNTIFS(D7:D10,"<>"),"Yes",""))

That worked. Thanks again.

 

[Fluff]

My pleasure.