Calculate a Category Total in Google Sheets
Generate and explain a Google Sheets formula that sums amounts by category for a specified month.
Example outputs
Prompt template
- Format
- Text Parameterized
- Inputs
- category (text) · Optional · Default: Food month (text) · Optional · Default: October
- Outputs
- Formula (text) Example (image)
I have a spreadsheet: column A contains dates, column B contains amounts, and column C contains categories. Write a Google Sheets formula that calculates the sum for the category "${category:Food}" during ${month:October}. Explain each part of the formula.
Replace the ${…} placeholders with your values
before using this prompt. See parameters
and defaults below
Parameters
Replace each placeholder with your own value, or use its default when one is provided
${category:Food}
category
Default: Food
${month:October}
month
Default: October
What you'll create
A spreadsheet formula sums amounts from column B using the dates in A and category labels in C, followed by an explanation of its components.
Frequently asked questions
Are the category and month fixed?
No. Both are replaceable inputs, defaulting to Food and October.
Comments
Tried this prompt? Share what you made, compare results, or ask a question