countif能否实现嵌套,怎么实现?答:函数都可以嵌套,COUNTIF嵌套的特点是第一参数必须为单元格区域,第二参数可以为数组。可以把你的例子详细地说一下,便于说明。 我先来举个例子吧,假设A1:C11这三列有一些数字,现在我想把每列都有的数字罗列出来,D1中输入=INDEX(B$1:B$12,SMALL(IF(COUNTIF(C$1:C$11,IF(COUNTIF(A$1:A$11,B$1:B$...
if函数能否与countif函数嵌套使用 要统计学生各学科的成绩等次,但想让...答:在I3输入如下公式下拉,如下图 =IF(COUNTIF(B3:H3,"A"),COUNTIF(B3:H3,"A")&"A","")&IF(COUNTIF(B3:H3,"B"),COUNTIF(B3:H3,"B")&"B","")&IF(COUNTIF(B3:H3,"C"),COUNTIF(B3:H3,"C")&"C","")&IF(COUNTIF(B3:...