Sumif formula - help required

Giganews Newsgroups
Subject: Sumif formula - help required
Posted by:  Natalie
Date: Wed, 3 May 2006

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

Replies