**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want to show in Cell E1 YES if Cells B6-B16,B21-31,B34-38,B41-B44,B47-B58 is YES and NO if Blank or No

Solved by G. B. in 38 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
23/07/2018 - 02:00

Hi

Excelchat Expert
23/07/2018 - 02:00

Hello!

Excelchat Expert
23/07/2018 - 02:00

Welcome to Got It Pro-Excel.

User
23/07/2018 - 02:00

Just have a quick question on a formula

User
23/07/2018 - 02:00

do you see the doc preview?

Excelchat Expert
23/07/2018 - 02:00

Yes, Got it

Excelchat Expert
23/07/2018 - 02:01

Yes, checking on it now

User
23/07/2018 - 02:01

awesome

User
23/07/2018 - 02:01

thanks

Excelchat Expert
23/07/2018 - 02:01

You're welcome

Excelchat Expert
23/07/2018 - 02:03

By the way, I will create the formula at your E1 as "yes" if all are yes and "no" if there's any "no" or blank value in any place of the ranges, right?

User
23/07/2018 - 02:03

yes correct

Excelchat Expert
23/07/2018 - 02:03

Thanks for the confirmation

User
23/07/2018 - 02:03

:)

Excelchat Expert
23/07/2018 - 02:03

A moment please :)

User
23/07/2018 - 02:03

sure

User
23/07/2018 - 02:07

you there? just checking as my page refreshed

Excelchat Expert
23/07/2018 - 02:07

Yes

User
23/07/2018 - 02:08

ahh good thing

Excelchat Expert
23/07/2018 - 02:08

Please give me more minutes to create the formula for you

Excelchat Expert
23/07/2018 - 02:08

Thank you :)

User
23/07/2018 - 02:08

sure no worries

Excelchat Expert
23/07/2018 - 02:16

Hi there,

User
23/07/2018 - 02:16

hi

Excelchat Expert
23/07/2018 - 02:17

A bit more time for testing

User
23/07/2018 - 02:17

will the session be cut off in 3 mins?

Excelchat Expert
23/07/2018 - 02:17

Please bear with me more time, we can extend 'till done

User
23/07/2018 - 02:17

oh perfect

User
23/07/2018 - 02:17

ah there

Excelchat Expert
23/07/2018 - 02:17

Thanks :)

User
23/07/2018 - 02:17

so the free exstension

User
23/07/2018 - 02:17

*saw

Excelchat Expert
23/07/2018 - 02:17

Yes, don't worry

User
23/07/2018 - 02:18

thank you

Excelchat Expert
23/07/2018 - 02:18

You're welcome

Excelchat Expert
23/07/2018 - 02:34

=if(or(countif(B6:B16,"No")>0,countif(B6:B16,"")>0,countif(B21:B31,"No")>0,countif(B21:B31,"")>0,countif(B34:B38,"No")>0,countif(B34:B38,"")>0,countif(B41:B44,"No")>0,countif(B41:B44,"")>0,countif(B47:B58,"No")>0,countif(B47:B58,"")>0),"No","Yes")

Excelchat Expert
23/07/2018 - 02:34

Finally, the formula above had been created

User
23/07/2018 - 02:34

perfect

Excelchat Expert
23/07/2018 - 02:34

Thank you

User
23/07/2018 - 02:34

thank you

Excelchat Expert
23/07/2018 - 02:34

By the way, you can put some data for testing

User
23/07/2018 - 02:34

this will be for all ranges I noted right?

Excelchat Expert
23/07/2018 - 02:35

Yes

Excelchat Expert
23/07/2018 - 02:35

The ranges mentioned above

User
23/07/2018 - 02:35

great

Excelchat Expert
23/07/2018 - 02:35

Thank you

User
23/07/2018 - 02:35

thank you so much for your help

User
23/07/2018 - 02:35

i think it was quite hard

User
23/07/2018 - 02:35

so really thank you

User
23/07/2018 - 02:35

:)

Excelchat Expert
23/07/2018 - 02:35

No, it's simple

Excelchat Expert
23/07/2018 - 02:36

just need the repitions of the formula use by the logical thinking of yes or no

User
23/07/2018 - 02:36

just tried it

User
23/07/2018 - 02:36

works like a charm

Excelchat Expert
23/07/2018 - 02:36

So, first, we've checked the existence of "no" and blank data on the ranges by using COUNTIF formula

Excelchat Expert
23/07/2018 - 02:37

Thank you :)

Excelchat Expert
23/07/2018 - 02:37

Any more concern regarding the formula created?

User
23/07/2018 - 02:37

No I'm good

User
23/07/2018 - 02:37

I will just review your formula

User
23/07/2018 - 02:37

for future use

User
23/07/2018 - 02:37

thank you!

Excelchat Expert
23/07/2018 - 02:38

Oh, I love to hear your feedback with us.

Excelchat Expert
23/07/2018 - 02:38

Thank you too :)

User
23/07/2018 - 02:38

:)

Excelchat Expert
23/07/2018 - 02:38

For any other Excel issues, please don't hesitate to come again. We will be glad to support you anytime.

User
23/07/2018 - 02:38

Will sure do

User
23/07/2018 - 02:38

bye for now

Excelchat Expert
23/07/2018 - 02:38

Thank you for coming at Got It Pro-Excel!

Excelchat Expert
23/07/2018 - 02:38

Have a nice day ahead

User
23/07/2018 - 02:38

you too

Excelchat Expert
23/07/2018 - 02:38

Cheers!!!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*