Generate an Excel SUMIF formula.

How to use it

Start with the same request, then adjust it to your sheet.

SUMIF is one of the fastest ways to total values that match a single condition.

Step by step

• Describe the condition and the range to total.
• Generate the SUMIF formula.
• Review the example and adapt the references.

Useful variations

• If you need multiple criteria, ask for SUMIFS.
• Use it for category totals, regions, product types, or status labels.

Worked example

Example input and output

Expected output