excel,如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,"a"

来源：学生作业帮编辑：拍题作业网作业帮分类：综合作业时间：2024/04/29 19:33:44

excel,如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,"a","") 区域等差适用于C18：C24等等
改写了一个公式进行改写 =IF(SUMPRODUCT(1/COUNTIF(INDIRECT("C"&4+ROW(A1)*7):INDIRECT("C"&10+ROW(A1)*7),INDIRECT("C"&4+ROW(A1)*7):INDIRECT("C"&10+ROW(A1)*7)))=4,"a","")
但是带进去提示缺少函数希望大家给看看给出一个正确的改写公式

你的意思好像想达到下拖时
D12的公式用用于C18:C24
D13的公式作用于C25:C31
如果这样的话,只需要将D11的公式中的C11:C17区域改写成INDIRECT(ADDRESS(11+(ROW()-11)*7,3)&":"&ADDRESS(10+(ROW()-10)*7,3))就行鸟
正确公式
=IF(SUMPRODUCT(1/COUNTIF(INDIRECT(ADDRESS(11+(ROW()-11)*7,3)&":"&ADDRESS(10+(ROW()-10)*7,3)),INDIRECT(ADDRESS(11+(ROW()-11)*7,3)&":"&ADDRESS(10+(ROW()-10)*7,3))))=4,"a","")

excel,如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,"a" =IF(C11=1,D11*$B$5-D11*$B$6)是用的IF函数吗? 请问这个EXCEL的公式应该怎么改才对 =sumif(e6:e11,">5",SUMPRODUCT(c6:c11,b6: 我这里有一个EXCEL中的乘积公式：=SUMPRODUCT($B2：$B11,C2:C11）,这里的$是什么意思呢? IF(OR(C12=ROUNDUP(C6-C11,2),C12=ROUNDDOWN(C6-C11,2)),"正确","错 excel表格里有=C11*10000/经济技术指标!C4, EXCEL {=SUMPRODUCT(1/COUNTIF(A1:A7,A1:A7))} EXCEl表格公式问题,前提如下：C8=IF(C6*C7=0,"",C6*C7);C12=IF(C10+C11=0,"" =OFFSET($U$14,ROW()-14,MONTH($B$5)-1) =+IF(C110,C62/C11,0) 这请高的手解释此Excel公式的含意 =SUM(IF((A2:A11="South")*(C2:C11="Meat"), excl中求和,且行和列都在变例如:D10=C10+D7*2+D8 D11=C11+D7*2+D8 E10=C10+E7 =IF(MOD(RIGHT(LEFT(C17,17)),2),"男","女") 有没有知道函数解释哈谢谢!