Create beginner Works with: Any AI

SUMIFS and COUNTIFS Multi-Criteria Formula Writer

Table output Has example

Total and count by several conditions.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Write SUMIFS and COUNTIFS formulas for my data. App: [SPREADSHEET_APP]. Data columns and ranges (for example date in A, region in B, product in C, amount in D): [DATA_COLUMNS_AND_RANGES]. Questions I want answered: [QUESTIONS]. Sample rows (fake data): [SAMPLE_ROWS].

For each question return a table row: Question | Formula | How it works | Check value from the sample. Include examples like these patterns:
Sum of amount for region "North" in October 2026: =SUMIFS(D:D, B:B, "North", A:A, ">="&DATE(2026,10,1), A:A, "<"&DATE(2026,11,1))
Count of orders above 500 for product in H2: =COUNTIFS(C:C, H2, D:D, ">500")
Sum with a wildcard (products beginning with "Kit"): =SUMIFS(D:D, C:C, "Kit*")
Average with conditions: =AVERAGEIFS(D:D, B:B, "North").

Also cover: using cell references for criteria; "not equal to" and blank/non-blank conditions; OR logic (add two SUMIFS or use SUMPRODUCT); dates as boundaries rather than text; why ranges must have the same size; case insensitivity; dynamic ranges using tables; and the typical errors (text numbers, hidden spaces, wrong criteria quotes). End with a tiny validation method: filter the data manually and compare the totals.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Question | Formula | Sample check
Total sales for region North in October 2026 | =SUMIFS(D:D, B:B, "North", A:A, ">="&DATE(2026,10,1), A:A, "<"&DATE(2026,11,1)) | 3,240 (rows 2, 5, 9)
Orders above 500 for the product in H2 | =COUNTIFS(C:C, H2, D:D, ">500") | 2
Average amount for North | =AVERAGEIFS(D:D, B:B, "North") | 810
Notes: dates are boundaries, not text; ranges must have equal size; OR logic: add two SUMIFS. Validation: filter manually and compare totals. Common errors: numbers stored as text and trailing spaces.

• sumifs