=FILTER('売上'!A2:E7,'売上'!B2:B7="果物",'売上'!C2:C7="完了")

=IFNA(FILTER('売上'!A2:E7,'売上'!B2:B7="衣類"),"該当なし")
