EXCEL =if（AND（60个值)," ",AVERAGE(H7:H66)) 如何计算

EXCEL =if（AND（60个值)," ",AVERAGE(H7:H66)) 如何计算

现在公式如下

=IF(AND(H7="",H8="",H9="",H10="",H11="",H12="",H13="",H14="",H15="",H16="",H17="",H18="",H19="",H20="",H21="",H22="",H23="",H24="",H25="",H26="",AND(H27="",H28="",H29="",H30="",H31="",H32="",H33="",H34="",H35="",H36="",H37="",H38="",H39="",H40="",H41="",H42="",H43="",H44="",H45="",AND(H46="",H47="",H48="",H49="",H50="",H51="",H52="",H53="",H54="",H55="",H56="",H57="",H58="",H59="",H60="",H61="",H62="",H63="",H64="",H65="",H66="")))," ",AVERAGE(H7:H66))

这个公式不知道错在哪了从46开始提示超出允许值。。
或者有简单点的公式么。。
在线等谢谢

举报该问题

其他回答

第1个回答 2013-01-14

楼主使用的是否为2003版的office？
如果是使用office2007，应该为255个逻辑值。
公式可以可以直接为：
=IF(AND(H7="",H8="",H9="",H10="",H11="",H12="",H13="",H14="",H15="",H16="",H17="",H18="",H19="",H20="",H21="",H22="",H23="",H24="",H25="",H26="",H27="",H28="",H29="",H30="",H31="",H32="",H33="",H34="",H35="",H36="",H37="",H38="",H39="",H40="",H41="",H42="",H43="",H44="",H45="",H46="",H47="",H48="",H49="",H50="",H51="",H52="",H53="",H54="",H55="",H56="",H57="",H58="",H59="",H60="",H61="",H62="",H63="",H64="",H65="",H66="")," ",AVERAGE(H7:H66))

第2个回答 2013-01-14

用这公式就可了，count(h7:h66）就是统计h7:h66是不是全部都是空值，不是就统计AVERAGE(H7:H66)这个区域的平均值

=IF(COUNT(H7:H66),AVERAGE(H7:H66),"")

第3个回答 2013-01-14

=IF(COUNT(H7:H66),AVERAGE(H7:H66),"")

如果用WPS2012或EXCEL2007,可用公式：
=IFERROR(AVERAGE(H7:H66),"")

第4个回答 2013-01-14

你试试
=IF(AND(H7:H66=""),"",AVERAGE(H7:H66))
按ctrl+shift+enter结束。本回答被提问者采纳

第5个回答 2013-01-14

公式改为：
=IF(COUNT(H7:H66),AVERAGE(H7:H66),"")
就可以了

1 2 下一页

相似回答

怎么用VB做8位CRC程序答：GetCRCHi = Choose(Ind + 1, &H0, &HC0, &HC1, &H1, &HC3, &H3, &H2, &HC2, &HC6, &H6, &H7, &HC7, &H5, &HC5, &HC4, &H4, &HCC, &HC, &HD, &HCD, &HF, &HCF, &HCE, &HE, &HA, &HCA, &HCB, &HB, &HC9, &H9, &H8, &HC8, &HD8, &H18, &H19, &HD9,...

大家正在搜

如何用EXCEL计算t值 excel如何去0值 if函数三个返回值 if值中信所if值 if真值 if表达式的值 if值是什么意思是什么 if值查询