=COUNTIF('売上'!$B$2:$B$7,"果物")

=SUMIF('売上'!$B$2:$B$7,"果物",'売上'!$E$2:$E$7)

=COUNTIFS('売上'!$C$2:$C$7,"完了",'売上'!$D$2:$D$7,">=2")

=SUMIFS('売上'!$E$2:$E$7,'売上'!$C$2:$C$7,"完了",'売上'!$D$2:$D$7,">=2")

=COUNTIF(A10:A12,"A~*")
