+ Reply to Thread
Results 1 to 5 of 5

Need a Formula for SUM for individual cell to add by entering number and then press enter

  1. #1
    Registered User
    Join Date
    08-03-2011
    Location
    Clearwater, FL
    MS-Off Ver
    Excel 2008 for Mac version 12.2
    Posts
    2

    Need a Formula for SUM for individual cell to add by entering number and then press enter

    I have an excel workbook that I'm working on and I'm trying to see if there is a SUM function or COUNT function or Formula that I can use that will quickly add a number up within an individual cell. So to give you an example, cell B7 , B8 and B9. B7 currently has the number 4 in it. However, throughout the day I want to be able to add to that number. Instead of just doing the math in my head and entering the new sum over the number 4
    that's currently in there, I would instead just like to enter a "2" in that cell where the number 4 currently is and then hit enter and then this formula that I am looking for will automatically add the number 4 that was already there with the new number 2 and now have the new sum of "6" in that cell after I hit enter. Then later on I may need to add another number 2 where the cell now has a 6 and hit enter and then get an "8" I'm almost positive there is a way to format this cell so it will just continuously add to the current number throughout the day. Please let me know if you have any suggestions? Thanks, Rich

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,259

    Re: Need a Formula for SUM for individual cell to add by entering number and then press en

    Welcome to the forum,

    Firstly, is your profile up-to-date? Are you still using Excel 2003?

    What you are describing cannot be done with a formula. Shall I move this to the VBA section for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-03-2011
    Location
    Clearwater, FL
    MS-Off Ver
    Excel 2008 for Mac version 12.2
    Posts
    2

    Re: Need a Formula for SUM for individual cell to add by entering number and then press en

    I believe I am on Mac Excel 2008. I guess I thought there was a function I could format the cell with that would just allow me to keep adding to the current cell by just putting in the new number that I would like to add to the current number and it would automatically update the cell with the new SUM. Any help is appreciated. Thanks, Rich

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,603

    Re: Need a Formula for SUM for individual cell to add by entering number and then press en

    Could you please update your profile? Thanks

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,259

    Re: Need a Formula for SUM for individual cell to add by entering number and then press en

    The only way you can do it is write a sum in the cell by clicking inside the cell each time and adding to the sum, e.g.

    =30+60

    then

    =30+60+80

    and so on.

    Please update your user profile to say Excel for Mac 2008.

+ 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. Replies: 12
    Last Post: 04-29-2024, 06:52 PM
  2. [SOLVED] Vlookup not working until i press in enter in cell
    By king10001 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2021, 12:13 AM
  3. How to run auto press 'Enter' key on certain cell before printing?
    By putritersenyum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2016, 08:50 AM
  4. [SOLVED] when press enter the formula sign is missing
    By doubleman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2015, 03:04 PM
  5. Date changes to <*insert number* when you click cell and press enter?
    By henryGKN in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-20-2014, 06:11 AM
  6. Cell gives incorrect value when I press ENTER.
    By Matthew.Newlove in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-25-2012, 10:58 AM
  7. [SOLVED] Cannot view cell content until I press enter
    By AnisKhan in forum Excel General
    Replies: 4
    Last Post: 06-09-2006, 01:10 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