电子表格软件处理数据 — 信息技术选择题
题目
某工作表中，B2:B5为商品类别，C2:C5为销售数量，E2:E5为销售额。现要统计类别为“饮品”且销售数量不少于3的记录的销售额总和，应使用哪一公式？
A. =SUMIF(B2:B5,"饮品",E2:E5)
B. =SUMIFS(E2:E5,B2:B5,"饮品",C2:C5,">=3")
C. =SUMIFS(E2:E5,B2:B5,"饮品",C2:C5,"<=3")
D. =COUNTIFS(B2:B5,"饮品",C2:C5,">=3")