The correct formula is =SUMIF(A2:A10, "Apple", B2:B10). It checks the product names in A2:A10 for "Apple" and sums the corresponding amounts in B2:B10.
Other options either swap ranges or use wrong argument order, causing errors or wrong results.
Option B is correct because it sums sales amounts in C2:C15 where product is "Banana" and quantity in B2:B15 is greater than 5.
Option B adds separate sums incorrectly. Option B uses wrong sum_range and criteria ranges. Option B mismatches criteria: ">5" on products and "Banana" on quantities, yielding no results.
Option C is correct because it uses the DATE function inside the criteria with concatenation (&) to form valid criteria strings.
Option C and C treat dates as text without concatenation, causing criteria to be treated literally, so no matches.
Option C tries to subtract sums but uses DATE inside quotes without concatenation, so it fails.
Option A correctly uses "S*" to match any product starting with 'S' and quantity less than 10.
Option A matches products ending with 'S', not starting.
Option A matches exact 'S' only.
Option A sums separately and adds, which is incorrect because it sums all products starting with 'S' plus all quantities less than 10, not combined.
Option D is correct: sums "Orange" sales where Region is not blank using "<>".
Option D omits Region criteria, including blanks.
Option D uses "" criteria to include only blank Regions.
Option D (SUMIF) lacks Region criteria, including blanks.