百度作业网Month\x05Type\x05cost
来源：学生作业帮 编辑：百度作业网作业帮 分类：综合作业 时间：2024/05/10 06:47:07
Month\x05Type\x05cost
May\x05Apple\x05112
Apr\x05orange\x0523
Apr\x05Apple\x0522
Mar\x05pear\x05225
May\x05pear\x0542
May\x05orange\x05788
May\x05Apple\x0512
Mar\x05pear\x05222
Apr\x05Apple\x0510
May\x05orange\x05211
Apr\x05orange\x0523
数据区域 A1:C12
"1、写公式计算在4月购买orange的次数
2、4月购买orange花费的总金额"
3、写公式计算每次购买pear的平均值花费
May\x05Apple\x05112
Apr\x05orange\x0523
Apr\x05Apple\x0522
Mar\x05pear\x05225
May\x05pear\x0542
May\x05orange\x05788
May\x05Apple\x0512
Mar\x05pear\x05222
Apr\x05Apple\x0510
May\x05orange\x05211
Apr\x05orange\x0523
数据区域 A1:C12
"1、写公式计算在4月购买orange的次数
2、4月购买orange花费的总金额"
3、写公式计算每次购买pear的平均值花费
1、=COUNTIFS(A2:A12,"Apr",B2:B12,"orange")
2、=SUMIFS(C2:C12,A2:A12,"Apr",B2:B12,"=orange")
3、=AVERAGEIF(B2:B12,"pear",C2:C12)
2、=SUMIFS(C2:C12,A2:A12,"Apr",B2:B12,"=orange")
3、=AVERAGEIF(B2:B12,"pear",C2:C12)