Sum if a cell contains text (wildcards)

sumifs wildcards text

SUMIFS with asterisks to total rows whose text contains a word.

The problem

Total the amounts for rows whose description contains a word.

Formula

=SUMIFS(D2:D5,G2:G5,"*"&"office"&"*")   -> 400

The stars mean anything before and after. The match ignores upper and lower case. A name-based variant: =SUMIFS(C2:C6,A2:A6,"*Lee*") totals sales for names containing Lee (250 in that sample).

Excel vs Sheets

Same in both.

Tested on sample data by the Cellwise checker (logs CW-PL-20261018-41 and -44). AI-made: the text, voice and visuals are generated by AI.

Checked before publishing: a check.