对于数组公式，重要的是您可以通过 Control + Shift + Enter 完成输入！然后公式将自动括在大括号中。如果只按 Enter 键，它将像普通公式一样工作。
公式的作用：
if 将遍历范围，如果单元格内容满足您的条件，则它将第二个数组中相应单元格的值放入结果数组中，否则放入 0然后
MAX 命令正在处理结果数组。重要的是，数组公式中使用的数组大小相同！
You can achieve this with an array formula.
=MAX(IF(B3:B12<>"";A3:A12;0))
Important with an array formula is that you finish entering by Control + Shift + Enter!! The formula will then be automatically enclosed in curly brackets. If you press only enter it will work as a normal formula.
What the formula will do:
The if will go through the range and if the cell content meets your condition then it puts the value from the according cell in the second array into his result array otherwise it puts in 0.
Then the MAX command is working on the resulting array. Important is that the arrays used in the array formula are the same size!
发布评论
评论（1）
您可以使用数组公式来实现此目的。
对于数组公式，重要的是您可以通过 Control + Shift + Enter 完成输入！然后公式将自动括在大括号中。如果只按 Enter 键，它将像普通公式一样工作。
公式的作用：
if将遍历范围，如果单元格内容满足您的条件，则它将第二个数组中相应单元格的值放入结果数组中，否则放入 0然后MAX命令正在处理结果数组。重要的是，数组公式中使用的数组大小相同！You can achieve this with an array formula.
Important with an array formula is that you finish entering by Control + Shift + Enter!! The formula will then be automatically enclosed in curly brackets. If you press only enter it will work as a normal formula.
What the formula will do:
The
ifwill go through the range and if the cell content meets your condition then it puts the value from the according cell in the second array into his result array otherwise it puts in 0.Then the
MAXcommand is working on the resulting array. Important is that the arrays used in the array formula are the same size!