close

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
quot;juniorquot;)

Any ideas?

Allan

Hello,

What about:

=SUMIF(D110,quot;*Junior*quot;,K1:K10)

Regards,
BondiSo simple....did not know we could use quot;*quot; like this! Thank you!

quot;Bondiquot; wrote:

gt; Hello,
gt;
gt; What about:
gt;
gt; =SUMIF(D110,quot;*Junior*quot;,K1:K10)
gt;
gt; Regards,
gt; Bondi
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄