如何查找特定单元格中数字范围内的总数值? [英] How to find total number of values in a number range in a particular cell.?
本文介绍了如何查找特定单元格中数字范围内的总数值?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
例如:
数据:
23至26,
40,
22,
7,
27至28,
49,
50至51,
48,
136,
169,
190至192,
17至22
DATA: 23 TO 26, 40, 22, 7, 27 TO 28, 49, 50 TO 51, 48, 136, 169, 190 TO 192, 17 TO 22
我在每个单元格中都有如上所示的这些数据,我如何得出一个公式,总结所有值的总数?
I have these datas as shown above in each individual cell, how do I come up with a formula that sums up all the total number of values?
我需要对数据进行一些更新。
I need to do some updating of datas.
谢谢你!
推荐答案
这将适用于 - 或TO:
This will work for " - " or " TO ":
=ROWS(INDIRECT(SUBSTITUTE(SUBSTITUTE(A1," - ",":")," TO ", ":")))
这篇关于如何查找特定单元格中数字范围内的总数值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文