计数单元格内的数值 [英] Count number of values within cell

问题描述

我正在Excel中计算单元格中的值的数量。到目前为止，我已经找到了很多方法来计算字符数，无论它们是空格，数字还是字母。但是，我想计算列表或单元格中的值的数量，如下所示：

我们在单元格A1中我有以下值序列： / p>

  38 39 101 102 114 115 116 117 118 119 120 121 122 123 124 125 
  

我希望单元格返回 16 ，表示单元格中有十六个值

有没有一个简单的方法来做这个Excel？

解决方案

p>如果你有一个已知的分隔符（破坏了这些值），并且你不需要测试数据是否是一个值或非价值，那么...

  = LEN（A1）-LEN（SUBSTITUTE（A1，[Your delimiter here]，））+ 1 
  / pre> 
 
 
  https：// support.microsoft.com/en-us/kb/187667  
 
I am trying to count the number of values within a cell, in Excel. So far I have found plenty of ways to count the number of characters, regardless of whether they're a space, number, or letter. However, I would like to count the number of values in a list or a cell, like so:

Let's say in cell A1 I have the following sequence of values:  
38 39 101 102 114 115 116 117 118 119 120 121 122 123 124 125
I would like for the cell to return 16, indicating that there are sixteen values in the cell.

Is there an easy way to do this with Excel?
解决方案
If you have a known delimiter (what breaks up the values) and you don't have to test your data for whether it's a value or non-value then...
=LEN(A1)-LEN(SUBSTITUTE(A1,"[Your delimiter here]",""))+1
https://support.microsoft.com/en-us/kb/187667

                        
这篇关于计数单元格内的数值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！