+ Reply to Thread
Results 1 to 3 of 3

Replace or substitute formula maybe? Not sure what one to use?

  1. #1
    Registered User
    Join Date
    02-24-2008
    Posts
    10

    Replace or substitute formula maybe? Not sure what one to use?

    Hi, I'm having a problem with some data i'm trying to work on.. heres the deal..

    The word 'OK' is in a selection cells

    Like this for example

    A........B.......C
    OK..............OK
    OK.....OK
    OK


    Each word OK represents the number 2. How do i get the total of the number in say cell D. For example in D1 the total would be 4, D2 would be 4 and D3 would be 2. What formula would i use to do this?

    I tried using the substitute and replace formula but they do not work when there is a blank value in a cell. I need a formula that i put to all three cells in the row to gain a total.

    Any help would be appreciated
    Thank you.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Try this formula in D1 copied down

    =COUNTIF(A1:C1,"OK")*2

  3. #3
    Registered User
    Join Date
    02-24-2008
    Posts
    10
    Perfect.. Thanks alot..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1