Consider the spreadsheet given below:

What is the output of the following formula in Cell C1? = SUMIF (A2: A7, "A", B2: B7)

Correct option is C

The formula = SUMIF(A2:A7, "A", B2:B7) will:
1. Check column A (A2:A7) for cells containing "A".
2. Sum the corresponding values in column B (B2:B7) where column A contains "A".
Step-by-Step Calculation: · Row 2: Column A has "A", so we include 15 from column B.
· Row 3: Column A has "A", so we include 20 from column B.
· Row 4: Column A has "B", so we skip this row.
· Row 5: Column A has "A", so we include 10 from column B.
· Row 6: Column A has "B", so we skip this row.
· Row 7: Column A has "A", so we include 5 from column B.
Final Summation: 15 + 20 + 10 + 5 = 50
Output of the formula: The result of = SUMIF(A2:A7, "A", B2:B7) is 50.