searching and summing using string within cell
 

Is there a way I can search on a string within a cell? I have a column of
personnel functions, column D, that includes, say, junior engineer 1, junior
engineer 2, senior engineer 1....lead engineer 1, etc. I'd like to sum all
the totals within another column, column K, that correlate to all juniors,
all seniors etc....I'm looking for something like =sumif(cell contains
"junior")

Any ideas?

Allan

searching and summing using string within cell
 

Hello,

What about:

=SUMIF(D1:D10,"*Junior*",K1:K10)

Regards,
Bondi

searching and summing using string within cell
 

So simple....did not know we could use "*" like this! Thank you!

"Bondi" wrote:

Hello,

What about:

=SUMIF(D1:D10,"*Junior*",K1:K10)

Regards,
Bondi