+ Reply to Thread
Results 1 to 6 of 6

Formula SUMPRODUCT works, now needs some tweaking, to True/False identify TEXT

  1. 04-29-2013, 04:41 PM #1
    steve08087
    steve08087 is offline
    Registered User
    Join Date
    04-28-2013
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    18

    Formula SUMPRODUCT works, now needs some tweaking, to True/False identify TEXT

    See attached example

    Excel Example Doc for 2 TEXT Formulas.xlsx

    Worksheet 1 - what I need to accomplish

    Worksheet 2 - what is working now - needs tweaking

    Thanks

    Steve
    Last edited by steve08087; 04-29-2013 at 05:27 PM.
    Reply With QuoteRegister To Reply
  2. 04-29-2013, 05:17 PM #2
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Formula SUMPRODUCT works, now needs some tweaking, to True/False identify TEXT

    steve08087,

    In sheet 'New Issues', cell A38 and copied down:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 04-29-2013, 05:34 PM #3
    loginjmor
    loginjmor is offline
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Formula SUMPRODUCT works, now needs some tweaking, to True/False identify TEXT

    Hi -

    Attached is a revised spreadsheet. I think I understand the first part, but I'm confused on the second part. On the second part you say all the exam codes are to be different. However, in row 41 you show 2 occurrences of exam code ABD1 and 2 occurrences of exam code PORTABD, yet you have that test as TRUE. I don't understand how you are differentiating which exam codes can be the same and which can't.

    Hope this helps.
    Attached Files Attached Files
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
    Reply With QuoteRegister To Reply
  4. 04-29-2013, 06:06 PM #4
    steve08087
    steve08087 is offline
    Registered User
    Join Date
    04-28-2013
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Formula SUMPRODUCT works, now needs some tweaking, to True/False identify TEXT

    That did it !!! Actually - I used this for my whole document - as I now realize that I didnt need to compare the exam codes... this is also very easy to edit on the fly - since sometimes my 1st column is blank, so I just simply edit the last piece of this IF formula to reference the next column, and then drag it down - for that section,

    Thanks !!!

    Steve
    Reply With QuoteRegister To Reply
  5. 04-29-2013, 06:11 PM #5
    steve08087
    steve08087 is offline
    Registered User
    Join Date
    04-28-2013
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Formula SUMPRODUCT works, now needs some tweaking, to True/False identify TEXT

    Thanks for your efforts,,, I know it's a bit confusing... the body sites had to be the same - and all i really wanted to compare - the exam codes are related but did not necessarily need to be the same - I guess I just didnt explain it well enough - that the exam codes could be the same or different - and have no impact on the True/False value - only the body site needed to be measured.

    I appreciate the time you spent though


    Very sincerely,

    Steve
    Reply With QuoteRegister To Reply
  6. 04-29-2013, 06:20 PM #6
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Formula SUMPRODUCT works, now needs some tweaking, to True/False identify TEXT

    You're very welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1