求如何用excel 函数求值。
发布网友
发布时间：2022-04-21 01:15
共2个回答
热心网友
时间：2022-06-17 01:26
第一个问题：
第一步：
第二步：
结果
第3个问题：
第一步：
第二步：
第三步：
计算结果：高于90分的中国和新加坡的女性人数
热心网友
时间：2022-06-17 01:26
1、sum(sumifs(g:g,c:c,"Department 3",e:e,{"China","Singapore","India","Japan"},f:f,"Male",d:d,"active"))/sum(countifs(c:c,"Department 3",e:e,{"China","Singapore","India","Japan"},f:f,"Male",d:d,"active"))
2、countifs(c:c,"Department 2",f:f,"Male",d:d,"active")-sum(countifs(c:c,"Department 2",e:e,{"China","Singapore","India","Japan"},f:f,"Male",d:d,"active"))
3、sum(countifs(f:f,"Female",e:e,{"China","Singapore"},g:g,">90"))
