Try this:

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

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Natalie" wrote in message
...
Hi,

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

Hope this makes sense..

Thanks
--
Natalie