作业帮Month\x05Type\x05costMay\x05Apple\x05112Apr\x05orange\x0523Apr\x05Apple\x0522Mar\x05pear\x05225May\x05pear\x0542May\x05orange\x05788May\x05Apple\x0512Mar\x05pear\x05222Apr\x05Apple\x0510May\x05orange\x05211Apr\x05orange\x0523数据区域 A1:C12"1、
来源：学生作业帮助网 编辑：作业帮 时间：2024/05/03 05:17:59
Month\x05Type\x05costMay\x05Apple\x05112Apr\x05orange\x0523Apr\x05Apple\x0522Mar\x05pear\x05225May\x05pear\x0542May\x05orange\x05788May\x05Apple\x0512Mar\x05pear\x05222Apr\x05Apple\x0510May\x05orange\x05211Apr\x05orange\x0523数据区域 A1:C12"1、
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的平均值花费
Month\x05Type\x05costMay\x05Apple\x05112Apr\x05orange\x0523Apr\x05Apple\x0522Mar\x05pear\x05225May\x05pear\x0542May\x05orange\x05788May\x05Apple\x0512Mar\x05pear\x05222Apr\x05Apple\x0510May\x05orange\x05211Apr\x05orange\x0523数据区域 A1:C12"1、
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)