LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
carl
 
Posts: n/a
Default Modifyiing a SumIF Formula to look for "OLA*

I tried modifying my SUMIF formula to sum if the data in COLK contains "OLA".
The modifiaction does not appear to work.

If OLA does appear in COLK, it will always be the right 3 characters.

Can my formula be modified to sum if COLK has OLA in the right 3 characters ?

Thank you in advance.


 
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
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM
How do I create a formula in Excel that will countif or sumif bef. bkclark Excel Worksheet Functions 4 November 10th 04 05:30 PM
Formula help SUM(IF((... HAL Excel Worksheet Functions 3 November 10th 04 03:30 PM
IF or SUMIF help for Overtime Formula Myrna Excel Worksheet Functions 2 November 8th 04 04:01 PM


All times are GMT +1. The time now is 07:32 PM.

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"