+ Reply to Thread
Results 1 to 28 of 28

How can I get a cell to recognize a value and then add a different cells value to a third?

  1. #1
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    How can I get a cell to recognize a value and then add a different cells value to a third?

    I have a sheet...see attached............. that I need help with. I color coded it to try and make it easier to understand what I want to do. So what I want to do is input a dollar amount in the yellow cells. A letter will be entered into the Blue cells. This letter will be one of the letters from the purple cells at the bottom. I need a formula that looks at the letter in the blue cell and then takes the dollar amount from the yellow cell next to it and adds it to a running total in the green cell. So if the letter in the blue cell is a Z it would get totaled in the green cell below the Z. If the letter in the blue cell is an A it would get totaled to the amount in the green cell below the letter A. I hope this all makes sense.
    Attached Files Attached Files
    Last edited by notsofast; 12-03-2014 at 10:36 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Stuck...need help

    Welcome to the Forum! Every person who asks a question here is stuck and needs help, so your title doesn't tell us much about what you need. Please revise it so that someone reading only your title will have an idea of whether they will know how to help you. Think in terms of someone googling for a problem just like yours and being able to find your title.

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: Stuck...need help

    changed as requested

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Need help with a formula

    Hi NotSoFast!..

    Yeah.. NotSoFast.. please spend some time to read the complete request.. Still it was not according to rule..
    Read the blue part again..

    BTW.. welcome to the forum..

    Your post title should accurately and concisely describe your problem
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  5. #5
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: Need help with a formula

    OK...tried it again. Not enough room to describe it all. Hope this one works.

    Thanks

  6. #6
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    thanks for the co-operation...

    Check this one..

    EF1053251.xlsx

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy paste the same formula in all GREEN cells..

  7. #7
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    That's frickin awesome.

    I couldn't get the A and the E to work though.

  8. #8
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    PINK A & E are actually "A " & "E "

    remove those space's..

  9. #9
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    I'm sorry I don't follow you. I need the A and the E.

  10. #10
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    !!! Do you still need some clarification ???

  11. #11
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    Had to read it several times but finally figured it out.

    THANKS !!

  12. #12
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    Oh.. my fault..

    I should have tell you that.. those A & E are contain space.. like "A( )" and "E( )"

    thanks for feedback..

  13. #13
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    It took me a few minutes but I finally got it. Still frustrated though. I can not get this to work on the actual spreadsheet. Can I attach the actual sheet for you to see?

  14. #14
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    Here is the actual sheet.

  15. #15
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    Try in D40,

    =SUMIF($E$15:$S$36,LEFT(D39),$D$15:$R$36)

    Then copy to other cells.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  16. #16
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    That is pretty close except it's not working correctly. I copied the formula to the first two cells....the X cell..D40..and the Y cell..F40. When I go back and enter a value in the sheet it all goes to the Y cell even if I put in an X.

  17. #17
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    Works for me. Please see attached.

    Note: in SUMIF first range is E:S & 2nd is D;R
    Attached Files Attached Files

  18. #18
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    WOW...yes the one you sent works. I cant seem to cut and paste the formula without it getting all messed up. Will this work with a 2 page sheet as well?

    see attached

  19. #19
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    Try this in Sheet2!D38,

    =SUMIF(Sheet1!$E$15:$S$36,LEFT(D37),Sheet1!$D$15:$R$36)+SUMIF($E$13:$S$34,LEFT(D37),$D$13:$R$34)

    Then copy to other cells.

  20. #20
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    If I can cut and paste correctly it looks like it will work !!!


    Thanks so much !!

  21. #21
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    Is there a way to add a formula that if I put in a dollar amount but do not enter a letter that the dollar amount will turn red until it is assigned a letter??

  22. #22
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    You can use conditional format,

    See attached.
    Attached Files Attached Files

  23. #23
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    That would be perfect !! Was the formatting already in the sample?

  24. #24
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    There was some other conditional formatting already in the sample. But the particular one was not.

  25. #25
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    I cleared all that other stuff out in the actual sheet i'm using....not the sample one here...do I use and IF Than?

  26. #26
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    I am trying to set this page up so that whatever I type in cell J4 is copied into cell G45 and the data in cell J6 to G47 but I cant seem to get it to work !! What am I doing wrong?!?!

  27. #27
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    G45 & G47 are 'Text' formatted cells. Right Click from these cells & select 'Format Cells' Select 'General' in Number tab >>OK. Then press F2 & Enter

  28. #28
    Registered User
    Join Date
    12-03-2014
    Location
    miami
    MS-Off Ver
    office 365
    Posts
    20

    Re: How can I get a cell to recognize a value and then add a different cells value to a th

    That was it !!

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stuck at work and stuck on a count function
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 12:47 AM
  2. Not sure what to do(Stuck)
    By sshanahan19 in forum Excel General
    Replies: 2
    Last Post: 03-22-2012, 01:51 PM
  3. Stuck...
    By Mike in forum Excel General
    Replies: 4
    Last Post: 05-22-2006, 03:15 PM
  4. Please help, I'm stuck
    By Ben in forum Excel General
    Replies: 2
    Last Post: 03-30-2006, 04:55 PM
  5. stuck
    By darkbearpooh1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-10-2006, 06:30 PM

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