In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
SUMIFS, COUNTIFS and AVERAGEIFS Summary Table
Prompt
App and version: {{SPREADSHEET_APP}}
Data sheet: headers and three sample rows: {{SHEET_STRUCTURE}}
The summary I want (rows, columns, measure, and any filters): {{SUMMARY_SPEC}}
Data range expectations (will rows be added, are there blanks or totals inside the range): {{RANGE_NOTES}}
Do this:
1. Propose the layout of the summary table with the row and column labels coming from the data (for example UNIQUE) or a typed list, and say which is safer here.
2. Write the one formula that goes in the top-left cell and can be filled right and down, with correct absolute and mixed references. Explain each criterion.
3. Show how to handle criteria with wildcards, dates between two cells, and "not equal" or "not blank".
4. Add a reconciliation row that proves the table sums to the total of the data, and tell me what it means if it doesn't.
5. Name two reasons these formulas return zero when the data looks right.
State assumptions. End with a three-cell test.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“SUMIFS, COUNTIFS and AVERAGEIFS Summary Table” is a free prompt for ChatGPT in the Productivity category, 178 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{SPREADSHEET_APP}}, {{SHEET_STRUCTURE}}, {{SUMMARY_SPEC}}, {{RANGE_NOTES}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 7 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.