LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave
 
Posts: n/a
Default SUMIF Question Criteria

I'm trying to sum numbers where the criteria is SOTB. In my data, SOTB is
often, but not always, buried in other text, but the function seems to
ignore any item which contains any words other than SOTB. Is there some way
I get it to recognize any entry that contains SOTB anywhere in the cell?

Thx all

Dave


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 question J Shrimps, Jr. Excel Worksheet Functions 5 January 20th 06 05:26 PM
SUMIF question (I think) Barb Reinhardt Excel Worksheet Functions 1 November 17th 05 02:36 PM
this may be simple, sumif question jim sturtz Excel Worksheet Functions 3 August 22nd 05 03:11 PM
sumif Question Jason Excel Discussion (Misc queries) 4 March 15th 05 04:11 PM
SUMIF question CarlosAntenna Excel Worksheet Functions 2 February 23rd 05 06:38 PM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"