macos Excel 公式给出 #VALUE！移植到 Mac 时出错
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1022766/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel formulas giving #VALUE! error when ported to Mac
提问by Patrick
I want to be able to sum up the number of cells in a range that have a non-null value in them. On a PC running XP and Excel I entered =SUM(IF(G$19:G$1034="",0,1))and it spit out the correct answer. Now the same spreadsheet on a Mac running Excel 2004 for Mac gives that a #VALUE!error. Any thoughts on why?
我希望能够总结一个范围内具有非空值的单元格数量。在运行 XP 和 Excel 的 PC 上，我输入=SUM(IF(G$19:G$1034="",0,1))并输出正确答案。现在，运行 Excel 2004 for Mac 的 Mac 上的相同电子表格会出现#VALUE!错误。关于为什么的任何想法？
采纳答案by jitter
You need to enter it as array (matrix) formula. After typing the formula don't hit enter but hit either
您需要将其作为数组（矩阵）公式输入。输入公式后不要按回车键而是按任一键
CMD+SHIFT+ENTERor CTRL+SHIFT+ENTER
CMD+ SHIFT+ENTER或 CTRL+ SHIFT+ENTER
Where CMD is the apple key. I'm not sure what the keycombination is on mac. But you can check in the help file. Entering array formula
其中 CMD 是苹果的关键。我不确定 mac 上的组合键是什么。但是你可以查看帮助文件。输入数组公式
回答by RLi
I realize that the post was mede a long time ago, but i recently and regularly have the same problem - and I always seem to forget the solution: Select the cell or range of cells that contains the array formula, press CONTROL+Uto edit the formula, and then press ?+RETURN.
我意识到该帖子很久以前就已发布，但我最近经常遇到同样的问题 - 我似乎总是忘记解决方案：选择包含数组公式的单元格或单元格范围，按CONTROL+U编辑公式，然后按?+ RETURN。
回答by Shiraz Bhaiji
It might be settings that control the separator character. That "," is the separator on one machine and something else, for example ";" is the separator character on the other.
它可能是控制分隔符的设置。那个“,”是一台机器上的分隔符和其他东西，例如“;” 是另一个的分隔符。
回答by e.James
I'm not sure if this is mac-specific. I have always used
我不确定这是否特定于 mac。我一直用
=COUNTA(G:G34)
for this purpose.
以此目的。
