Google电子表格Arrayformula带有IF和条件
我需要有关Google电子表格的帮助。我尝试了所有事情，但是不知何故我无法弄清楚如何解决这个问题。
我有5列，其中4列是“蓝色，黄色，绿色和白色”，另一个是“结果”，
在结果中应包含其他列的值，但在某些条件下。
在屏幕截图中，我手动输入结果。我尝试了我能够像arrayforumula（IFS（和（条件））等的所有东西，但无法正常工作。我从字面上花了10h，真的很喜欢任何帮助
。 .sstatic.net/ifpzK.png" rel="nofollow noreferrer">https://i.sstatic.net/ifpzK.png
I need some help with google spreadsheet. I tried everything but somehow I am not able to figure out how to solve this.
I have 5 columns, 4 of them are "Blue, Yellow, Green and White" and the other is "Result"
In the Result it should contain the value from the other columns but with some conditions.
In the screenshot I entered the Results manually. I tried everything I am capable of like Arrayforumula(Ifs(and(CONDITIONS)) etc but not working. I spend literally 10h and would really appreciating any help. is that even possible?
Example: https://i.sstatic.net/ifpzK.png
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
E2中的以下公式将在“结果”列中产生所有必需的结果：
用无限范围进行此工作将需要更多的工作。如果“蓝色”列和其他三个在给定的行中都空白（我认为） - 您没有将其定义为可能性，那么它也可能无法正常工作。
The following formula in E2 will produce all the required results in the 'Result' column:
Making this work with infinite ranges would need more work. It also might not work as expected if both the 'Blue' column and the other three are blank in a given row (I think) - you didn't define this as a possibility.