Sumif formula - help required

N

Natalie

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
 
R

RagDyeR

Try this:

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

HTH,

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


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
 
Top