software

What formula do I use to get a sum for all values from collum quot;Dquot; only if
there is a particular word in columm quot;Bquot; of the same row?Try:

=SUMIF(B1:B100,quot;your wordquot;,D1100)

HTH
Jean-Guy

quot;Rogerquot; wrote:

gt; What formula do I use to get a sum for all values from collum quot;Dquot; only if
gt; there is a particular word in columm quot;Bquot; of the same row?
gt;

Thanks
The problem is that I have multiple words in each cell amp; I want just to
choose 1

quot;pinmasterquot; wrote:

gt; Try:
gt;
gt; =SUMIF(B1:B100,quot;your wordquot;,D1100)
gt;
gt; HTH
gt; Jean-Guy
gt;
gt; quot;Rogerquot; wrote:
gt;
gt; gt; What formula do I use to get a sum for all values from collum quot;Dquot; only if
gt; gt; there is a particular word in columm quot;Bquot; of the same row?
gt; gt;

Sumif will accept wildcards in its criteria. Try:

=sumif(B:B,quot;*word*quot;,D)

--
Regards,
Fredquot;Rogerquot; gt; wrote in message
...
gt; Thanks
gt; The problem is that I have multiple words in each cell amp; I want just to
gt; choose 1
gt;
gt; quot;pinmasterquot; wrote:
gt;
gt;gt; Try:
gt;gt;
gt;gt; =SUMIF(B1:B100,quot;your wordquot;,D1100)
gt;gt;
gt;gt; HTH
gt;gt; Jean-Guy
gt;gt;
gt;gt; quot;Rogerquot; wrote:
gt;gt;
gt;gt; gt; What formula do I use to get a sum for all values from collum quot;Dquot; only if
gt;gt; gt; there is a particular word in columm quot;Bquot; of the same row?
gt;gt; gt;