检查数组中引用的单元格是否为0或为空 [英] Check if the referenced cell inside an array is `0` or is empty

问题描述

我需要找到一些方式来分开零和空单元格。 OFFSET函数的数组值的结果。在附图中，我想在单元格 D4 和 D6 中有空字符串。

B5 等于 =和 B7 真的是空的。我不想区分这些情况。

• 我只对公式解决方案感兴趣，这些公式解决方案为索引向量的每一行使用不断的
  单元格数量。




• 没有VBA。




• 作为最后的手段，我将
  接受使用流行的MoreFunc Excel包或
  的其他免费和公开的Excel添加-上。

我知道如何使用 RExcel ，但这太复杂了，在重新计算过程中会有
问题/细胞依赖困难（更不用说安装R和朋友）。

---

这是我的一个相关问题：

$ a bref = -conte / 19841772？noredirect = 1＃comment29507329_19841772>是否有一个函数，当输入引用为空时会返回，如果不是，则返回其内容？

解决方案

好的，我找到了一个。其实很简单

  = COUNTBLANK（<参考数组>）
  

I need to find some way of telling apart zeroes and empty cells in e.g. the results of the array value of OFFSET function. In the included illustration, I'd like to have empty string in the cells D4 and D6.

The B5 equals ="", and B7 is genuinely empty. I don't want to distinguish between these cases.

• I'm interested only in formula solutions that take constant number of cells for each row of index vector.

• No VBA.

• As a last resort I will accept a solution that uses the popular MoreFunc Excel package or other free and publicly available Excel add-on.

I know how to do that using RExcel, but this is too sophisticated, and there will be issues/difficulties with cell dependence during recalculations (not to mention installation of R and "friends").

---

Here is a related question of mine:

Is there a function, that would return "" when input ref is empty, and its contents if it is not?

解决方案

OK, I've found one. Actually it was very simple.

=COUNTBLANK(<array of refernces>)

这篇关于检查数组中引用的单元格是否为0或为空的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！