Posted to microsoft.public.excel.misc

Natalie

Posts: n/a

Sumif formula - help required

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF where values to be summed are formula	Zakynthos	Excel Worksheet Functions	10	July 27th 05 04:05 PM
sumif formula returns incorrect value	modular_brian	Excel Worksheet Functions	1	June 16th 05 10:29 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Modifyiing a SumIF Formula to look for "OLA*	carl	Excel Worksheet Functions	4	January 3rd 05 07:31 PM

All times are GMT +1. The time now is 06:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us