Calculate a Category Total in Google Sheets

Generate and explain a Google Sheets formula that sums amounts by category for a specified month.

By Threads — Published on Oct 18 — Modified on Oct 18

Example images

Calculate a Category Total in Google Sheets output 1

Prompt template

Format: Text Parameterized
Inputs: category (text) · Optional · Default: Food month (text) · Optional · Default: October
Outputs: Formula (text) Example (image)

Replace the ${…} placeholders with your values before using this prompt. See parameters and defaults below.

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.