z**********i
发帖数: 12276 | 1 =(COUNTIFS($E$23:$E$172,">0",$E$23:$E$172,"<9",Residents!$E$9:$E$158,"*")/$F
$13)
如何把COUNTIFS变成COUNTIF, SUMIF 或者SUMPRODUCT, 因为2003版本没有COUNTIFS.
多谢!! | g*********r
发帖数: 2847 | 2
$F
add a new column to indicate (0 or 1) if those values in Column E are
between 0 and 9 or not and then sum up
【在 z**********i 的大作中提到】
: =(COUNTIFS($E$23:$E$172,">0",$E$23:$E$172,"<9",Residents!$E$9:$E$158,"*")/$F
: $13)
: 如何把COUNTIFS变成COUNTIF, SUMIF 或者SUMPRODUCT, 因为2003版本没有COUNTIFS.
: 多谢!!
| z**********i
发帖数: 12276 | 3 =SUMPRODUCT(($E$23:$E$172>0)*($E$23:$E$172<=9)*(Residents!$E$9:$E$158<>"")*1
)/$F$13
多谢回复,后来,一个同事帮着解决拉.
EXCEL用得很少,基本的FUNCTION都没有搞清.
发个双黄包,不诚敬意.
【在 g*********r 的大作中提到】
:
: $F
: add a new column to indicate (0 or 1) if those values in Column E are
: between 0 and 9 or not and then sum up
|
|
