在a10
=(SUM(A1:A10)-MAX(A1:A10)-MIN(A1:A10))/(COUNT(A1:A10)-2)是什么意
车刀A10什么意思
SUMPRODUCT(MOD(ROW(A1:A10),2),A1:A10)理解
sum(A1:A10+B1:B10)
=COUNTIF(A1:A10,"A")+COUNTIF(A1:A10,"E")+COUNTIF(A1:A10,"F")
excel中,公式“=COUNTIF(A1:A10,A1)“与“=COUNTIF(A1:A10,A1:A10)”的结果是
EXCLE中A2=A1*A10,A3=A2*A10,A4=A3*A10.A10随时会变动,公式怎么写
=sumproduct(--isnumber(find("猴",a1:a10)))
公式=SUM(A1:A9)-A10,为什么A10是空值时这个公式显示是错误的
等差数列{an}中,3(a3+a5)+2(a7+a10+a13)=24,则a4+a10=?
=SUM(LARGE(A1:A10,ROW(INDIRECT(1&":"&COUNTA(A1:A10)*0.2))))/