+ Reply to Thread
Results 1 to 3 of 3

Enter cumulative values

  1. #1
    Registered User
    Join Date
    11-02-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    7

    Enter cumulative values

    Thanks a lot to this Forum for the great information in it.

    I am trying to have a cell where I enter values, one at a time in the same cell, and another cell, adds the values entered.

    For example, on cell A1, I enter: 1,enter, 3, enter, 2, enter. Cell B1 will show: 1 then 4, then 6 (as the values on A1 are entered).

    I have tried with circular reference, nut have not found a way to have it working correctly.

    Any ideas will be highly appreciated

    Thanks

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

    Re: Enter cumulative values

    You will need VBA - shall I move the thread 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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-02-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    7

    Re: Enter cumulative values

    As I am using Excel on an iPad, I cannot use VBA

+ 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. [SOLVED] Cumulative sum (if values match)
    By Median in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-17-2018, 09:34 AM
  2. Cumulative Sum of values in an array
    By seigna in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2013, 06:59 PM
  3. Take cumulative column down to instantaneous values
    By zax11029 in forum Excel General
    Replies: 2
    Last Post: 07-14-2010, 11:14 AM
  4. Cumulative Values
    By stevewilde in forum Excel General
    Replies: 2
    Last Post: 08-14-2009, 04:33 AM
  5. How to calculate cumulative values
    By Learner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2006, 02:35 AM
  6. [SOLVED] Cumulative Values
    By David in forum Excel General
    Replies: 2
    Last Post: 08-04-2006, 06:55 PM
  7. [SOLVED] List cumulative values in a column
    By danie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 12:40 AM

Tags for this Thread

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