本帖最后由 kkdevil04 于 2020-6-5 09:48 编辑
- SUM(COUNTIFS(H2043:AK2044,"A"),COUNTIFS(H2043:AK2044,"B"),COUNTIFS(H2043:AK2044,"C"),COUNTIFS(H2043:AK2044,"D"),COUNTIFS(H2043:AK2044,"E"),COUNTIFS(H2043:AK2044,"F"),COUNTIFS(H2043:AK2044,"G"),COUNTIFS(H2043:AK2044,"H"),COUNTIFS(H2043:AK2044,"I"),COUNTIFS(H2043:AK2044,"J"),COUNTIFS(H2043:AK2044,"K"),COUNTIFS(H2043:AK2044,"L"),COUNTIFS(H2043:AK2044,"M"),COUNTIFS(H2043:AK2044,"N"),COUNTIFS(H2043:AK2044,"O"),COUNTIFS(H2043:AK2044,"P"))
复制代码
如果求个数合计的值过多,这个方法肯定就不会用了,实在会太长,有没有简单点的方法呢? |