Search for a string in a column and sum values

you can try something like this:

Name the table with the phrases and values "Data", and make the table that summarizes the information "Summary"

Make the first row in both tables a header row

for the table "Summary"

enter the search phrase in column A (as shown).

select cell B2 and type (or copy and paste from here) the formula:

=SUMIF(Data::A, "*"&A2&"*",Data::B )

shorthand for this is:

B2=SUMIF(Data::A, "*"&A2&"*",Data::B )

to fill this formula down, select cell B2, copy

select cells B2 thru the end of column B, paste

In the formula above, the argument:

"*"&A2&"*"

joins the search phrase with a preceding asterisk, and a one following.

... so if the search term is "content" then the argument:

"*"&A2&"*"

will result in

"*content*"

the "*" is a wildcard character and will accept any text before (or after) the search term

Hi Andreas,

Here is one way (perhaps not quite what you want).

This table has a Header Row and a Footer Row.

Add extra columns to the Source table and type the search words in Row 1

Formula in C2 (and Fill Down and Fill Right)

=IFERROR(SEARCH(C$1,$A2),"")

SEARCH finds the starting position of a search word (keyword or keywords or Keywords or KEYWORD).

Use the FIND function if upper/lower case is important.

IFERROR inserts "" (NULL) if SEARCH can not find the string.

Formula in Footer Cell C11 (and Fill Right)

=COUNTIF(C,">0")

With Header and Footer Rows, you can add more Body Rows and the formulas will automatically adjust.

Regards,

Ian.