Prompt Library

← All prompts · Coding Basics

Spreadsheet Formula Helper

Coding Basics

Get the right Excel/Google Sheets formula.

Prompt

In [Google Sheets/Excel], my data is: column A = [..], B = [..], C = [..], rows 2 to [n].
I want to [goal, e.g. sum C where A is 'Paid' and B is in March].
Give the formula, explain each part, and show the result on these 3 sample rows: [paste].

Tips

Describe columns by header names, not just letters, to avoid mix-ups.

Example output (excerpt)

=SUMIFS(C2:C200, A2:A200, "Paid", B2:B200, ">="&DATE(2026,3,1), B2:B200, "<"&DATE(2026,4,1))

← Back to all prompts