+ Reply to Thread
Results 1 to 6 of 6

Formula to SUM unknown number with a known number and populate in another cell

  1. #1
    Registered User
    Join Date
    07-14-2016
    Location
    Visalia
    MS-Off Ver
    Latest
    Posts
    16

    Formula to SUM unknown number with a known number and populate in another cell

    Hello Folks,

    I am creating a template for co-workers and need some help finding a particular formula. I will do my best to explain it. I am working with Column M, Cell 2, and Column O, Cell 2. In M2, my co workers will be entering a certain dollar amount plus (+) $6,000.00 (the $6,0000.00 will always be the same or fixed). I don't know is what number my co-workers will be entering, it will always change. In O2, I need the total of the 'unknown number' plus (+) the $6,000.00 to automatically calculate and populate in this cell when my co-workers enter their information in M2.

    I really need help with this as soon as possible. Thank you so much.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to SUM unknown number with a known number and populate in another cell

    If I understand what you want, this formula entered in O2:

    =IF(M2="","",M2+6000)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    07-14-2016
    Location
    Visalia
    MS-Off Ver
    Latest
    Posts
    16

    Re: Formula to SUM unknown number with a known number and populate in another cell

    Yes! Thank you! It works! Fantastic. Thank you Tony Valko

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to SUM unknown number with a known number and populate in another cell

    You're welcome. Thanks for the feedback!

  5. #5
    Registered User
    Join Date
    07-14-2016
    Location
    Visalia
    MS-Off Ver
    Latest
    Posts
    16

    Re: Formula to SUM unknown number with a known number and populate in another cell

    Tony,

    I hate to have to pry your brain, but can you help me on two more formulas? I need a formula that will calculate what 35% is of the value that populates in cell I3. That number needs to appear in cell K3.

    All these forumlas I'm trying to gather will help me come up with a final formula (and probably the most complicated one).

    Thank you in advance.

  6. #6
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Formula to SUM unknown number with a known number and populate in another cell

    Hello
    I suppose you want
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in K3
    Note: This question is different from what the title says it.
    You must open a new thread for each new issue.

+ 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. VBA Inserting formula in cell: sum unknown number of cells
    By Excel@DataMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 07:03 PM
  2. Replies: 8
    Last Post: 11-18-2013, 04:24 PM
  3. Populate chart with data from column (Unknown number of rows)
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2012, 07:25 AM
  4. if, then formula help for an unknown number
    By flopped.quads00 in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 11:44 PM
  5. VBA Inserting formula in cell: sum unknown number of cells
    By jcb in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-22-2011, 12:15 PM
  6. Replies: 7
    Last Post: 03-22-2010, 05:22 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