software

Hi,

I have written a sumif.. =SUMIF(B6:B162,quot;EMAPquot;,F6:F162) however there are
various instances of quot;EMAPquot; not all of which state quot;EMAPquot; exactly.. I want to
add everything in rows F6:F162 where B6:B162 says quot;EMAPquot; anywhere..

Hope this makes sense..

Thanks
--
Natalie

Try this:

=SUMIF(B6:B162,quot;*EMAP*quot;,F6:F162)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===quot;Nataliequot; gt; wrote in message
...
Hi,

I have written a sumif.. =SUMIF(B6:B162,quot;EMAPquot;,F6:F162) however there are
various instances of quot;EMAPquot; not all of which state quot;EMAPquot; exactly.. I want
to
add everything in rows F6:F162 where B6:B162 says quot;EMAPquot; anywhere..

Hope this makes sense..

Thanks
--
Natalie
Works a treat... thanks
--
Nataliequot;RagDyeRquot; wrote:

gt; Try this:
gt;
gt; =SUMIF(B6:B162,quot;*EMAP*quot;,F6:F162)
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt;
gt; quot;Nataliequot; gt; wrote in message
gt; ...
gt; Hi,
gt;
gt; I have written a sumif.. =SUMIF(B6:B162,quot;EMAPquot;,F6:F162) however there are
gt; various instances of quot;EMAPquot; not all of which state quot;EMAPquot; exactly.. I want
gt; to
gt; add everything in rows F6:F162 where B6:B162 says quot;EMAPquot; anywhere..
gt;
gt; Hope this makes sense..
gt;
gt; Thanks
gt; --
gt; Natalie
gt;
gt;
gt;

Thank YOU for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Nataliequot; gt; wrote in message
...
gt; Works a treat... thanks
gt; --
gt; Natalie
gt;
gt;
gt; quot;RagDyeRquot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; =SUMIF(B6:B162,quot;*EMAP*quot;,F6:F162)
gt; gt; --
gt; gt;
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt; ================================================== ===
gt; gt; Please keep all correspondence within the Group, so all may benefit!
gt; gt; ================================================== ===
gt; gt;
gt; gt;
gt; gt; quot;Nataliequot; gt; wrote in message
gt; gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I have written a sumif.. =SUMIF(B6:B162,quot;EMAPquot;,F6:F162) however there
are
gt; gt; various instances of quot;EMAPquot; not all of which state quot;EMAPquot; exactly.. I
want
gt; gt; to
gt; gt; add everything in rows F6:F162 where B6:B162 says quot;EMAPquot; anywhere..
gt; gt;
gt; gt; Hope this makes sense..
gt; gt;
gt; gt; Thanks
gt; gt; --
gt; gt; Natalie
gt; gt;
gt; gt;
gt; gt;