+ Reply to Thread
Results 1 to 3 of 3

Adding a columns displayed value not working

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    The Hills, Arkansas
    MS-Off Ver
    Excel 2016
    Posts
    69

    Question Adding a columns displayed value not working

    I'm having a problem with a formula recognizing a value, from a formula, in another cell.

    Cell B1 checks to see if C1 starts with "free" if so change B1's value to 1.

    Cell A1 sums column B.

    The problem is that A1 is not adding the values of column B together.


    Please Login or Register  to view this content.
    Last edited by ragingfred; 03-29-2013 at 03:43 PM.

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Adding a columns displayed value not working

    hi there,

    in B1, the "1" is being recorded as a text because of the quotes around it. try this instead:

    Please Login or Register  to view this content.
    also, FREE is 4 characters long, but you are extracting 5 characters from C1 and then comparing that with "FREE". are you getting any results at all?

    you should share a sample workbook so that an informed and pertinent solution could be provided.

    1198
    Last edited by icestationzbra; 04-01-2013 at 01:29 AM.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Registered User
    Join Date
    02-28-2013
    Location
    The Hills, Arkansas
    MS-Off Ver
    Excel 2016
    Posts
    69

    Re: Adding a columns displayed value not working

    You are right, Free is only 4 instead of 5, a mistake on my part. On the other hand removing the quotes did the trick.

    Thank you,

    Fred

+ 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