Prompt Details
Model
Chat - (gpt-5.5)
Token size
1,016
Example input
[Platform]: Excel 365
[Task]: Calculate the total sales amount for Product "Laptop" in January 2026.
[TargetCell]: F2
[DataStructure]: Column A = Date, Column B = Product, Column C = Sales Amount. Data starts from row 2.
[Requirements]: Return 0 if no matching records are found.
Example output
=IFERROR(SUMIFS(C:C,B:B,"Laptop",A:A,">="&DATE(2026,1,1),A:A,"<"&DATE(2026,2,1)),0)
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
4
Views
GPT-5.5
Generate accurate, optimized, and production-ready formulas for Microsoft Excel and Google Sheets in seconds. Simply describe your task, spreadsheet structure, and requirements—the AI automatically selects the best functions (XLOOKUP, FILTER, QUERY, LET, LAMBDA, ARRAYFORMULA, and more) to deliver a clean, efficient solution ready to use.
...more
Added 1 week ago
