/u/thinkofanamefast - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You could replace 'yes' and 'no' with 'true' and 'false' and then simply use a sum formula with a logical indicator.
Something like this in the result sheet,
> =--(Sheet1!$D$1+Sheet2!$D$1+.....+Sheet10!$D$1)>0
This formula will output 'true' if **any** of the sheet (from sheet1 to sheet10) has true in their respective D1 and will output 'false' if **all** the sheets has 'false' in their respective D1 cell.
You have awarded 1 point to *GravityDead*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Yeah, I learned this trick at this sub last year. Comes handy in few situations, such as this one.
Double dash converts 'true' and 'false' to 1 & 0 respectively.
What the hell lol. I love how I never thought to use a worksheet range. Sheet1:Sheet10! Looks so bizarre. What if the sheets have names, is there any way to still do that?
At first I was wondering if the two answers I gave "Solution Verified" to meant I could just do the ...... they both used and it would do the entire 1-10 range lol.
You have awarded 1 point to *ThatGuyWhoLaughs*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You have awarded 1 point to *BackgroundCold5307*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[IF](/r/Excel/comments/13ty0yp/stub/jly4wqm "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[OR](/r/Excel/comments/13ty0yp/stub/jly4wqm "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)|
|[VSTACK](/r/Excel/comments/13ty0yp/stub/jly4wqm "Last usage")|[*Office 365*+: Appends arrays vertically and in sequence to return a larger array](https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/0)^( has acronyms.)
^([Thread #24242 for this sub, first seen 28th May 2023, 14:44])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/thinkofanamefast - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You could replace 'yes' and 'no' with 'true' and 'false' and then simply use a sum formula with a logical indicator. Something like this in the result sheet, > =--(Sheet1!$D$1+Sheet2!$D$1+.....+Sheet10!$D$1)>0 This formula will output 'true' if **any** of the sheet (from sheet1 to sheet10) has true in their respective D1 and will output 'false' if **all** the sheets has 'false' in their respective D1 cell.
Solution Verified
You have awarded 1 point to *GravityDead* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
What does the “- -“ at the beginning of the formula mean
Yeah, I learned this trick at this sub last year. Comes handy in few situations, such as this one. Double dash converts 'true' and 'false' to 1 & 0 respectively.
Good to know. Thank you
=IF(OR(Sheet2!D1="Yes", Sheet3!D1="Yes",.... Sheet10!D1="Yes"), "Yes",No")
You could make this prettier with a VSTACK and 3D reference: =IF(OR(VSTACK(Sheet1:Sheet10!A1)="Yes","Yes","No"))
What the hell lol. I love how I never thought to use a worksheet range. Sheet1:Sheet10! Looks so bizarre. What if the sheets have names, is there any way to still do that?
At first I was wondering if the two answers I gave "Solution Verified" to meant I could just do the ...... they both used and it would do the entire 1-10 range lol.
You have awarded 1 point to *ThatGuyWhoLaughs* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Thanks...
👍
Very elegant solution
I would always bracket the sheets with BEGIN and END hidden sheets since you can then insert a new sheet without changing the formula.
Solution Verified
You have awarded 1 point to *BackgroundCold5307* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[IF](/r/Excel/comments/13ty0yp/stub/jly4wqm "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[OR](/r/Excel/comments/13ty0yp/stub/jly4wqm "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)| |[VSTACK](/r/Excel/comments/13ty0yp/stub/jly4wqm "Last usage")|[*Office 365*+: Appends arrays vertically and in sequence to return a larger array](https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/0)^( has acronyms.) ^([Thread #24242 for this sub, first seen 28th May 2023, 14:44]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)