Choose the correct option.
Rising Stars Inc. has many suppliers as shown in the image. They will make payment to only those
suppliers whose materials meet their specifications. How can the total amount payable be
calculated based on the given information?
OPTIONS
=COUNTIF(B2:B7,"Yes", C2:C7)
=COUNT(B2:87,"Yes", C2:C7)
-SUM(B2:83,86:87)
-SUMIF(B2:87,"Yes",C2:C7)
