Spreadsheet Formula Generator — illustrative example

INPUT
Excel or Google Sheets, English function names and comma separators. A2:A4 = Paid, Unpaid, Paid. B2:B4 = 10, 20, 5 as numbers. Sum only Paid amounts.

RESULT
=SUMIF(A2:A4,"Paid",B2:B4)

Expected result: 15, from 10 + 5. The Unpaid row contributes nothing. Adapt separators for your spreadsheet locale.

REVIEW
Formula generation works best with column names and expected results. Choose Excel or Sheets and include examples of blanks or errors.

This is a teaching example, not a live execution record.