Loading
Preparing the page
Public context is loading before any interactive tool code.
Preparing the page
Public context is loading before any interactive tool code.
Choose one of six documented formula recipes, validate simple A1 references, and copy a reviewable Excel formula without uploading workbook data.
Your checked result will appear here.
The builder validates ranges and their dimensions before assembling the formula. A text criterion remains a quoted argument rather than becoming executable formula syntax.
Choose the smallest function that matches the worksheet job. The examples use commas and current-sheet A1 references.
=SUM(A2:A10)Required input: range.
=AVERAGE(A2:A10)Required input: range.
=COUNTA(A2:A10)Required input: range.
=SUMIF(B2:B100,"paid",C2:C100)Required input: criteria range · text criterion · sum range.
=COUNTIF(B2:B100,"paid")Required input: range · text criterion.
=XLOOKUP(E2,A2:A100,C2:C100,"Not found")Required input: lookup cell · lookup range · return range · fallback.
The criteria range and sum range both cover rows 2 through 100. The text criterion is quoted, producing the documented three-argument order.
{
"recipe": "sumif",
"arguments": {
"criteria_range": "B2:B100",
"criterion": "paid",
"sum_range": "C2:C100"
}
}=SUMIF(B2:B100,"paid",C2:C100)
Observed: three arguments · 99 rows in each range
B2:B100 → C2:C99This bounded recipe requires criteria and sum ranges with the same height and width.
The builder checks syntax inputs, not workbook values. Compatibility and calculation still belong to Excel and the workbook.
XLOOKUP is not available in Excel 2016 or Excel 2019 even though those versions can encounter a workbook created with it.
Some regional settings require semicolons where these examples use commas.
Confirm headers, blank rows, error values, text-formatted numbers and the first and last included row.
Run the formula on a small controlled fixture before applying it to a production workbook.
MCXAI does not open the workbook, inspect cell types or evaluate the result. Copy the formula only after reviewing every reference.