+ Reply to Thread
Results 1 to 6 of 6

Cumulative Sum SOS No VBA Expert

  1. #1
    Registered User
    Join Date
    01-17-2018
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    4

    Exclamation Cumulative Sum SOS No VBA Expert

    Hello to all,
    I am writing to try to come to terms with a problem that I have difficulty solving.

    I have a table of data where numeric values ​​are entered periodically in cell B3.
    I expect that in cell C13 appears the sum of all the values ​​entered over time.
    For example in B3 I insert from Monday to Friday 100, 200, 300, 400 and 500.
    Daily in C 13 should appear 100, 300, 600, 1000 and 1500.

    This operation is applied to several cells inside the same worksheet but for now I stick to a single to understand the underlying logic.

    I tried to impose an iterated calculation to Excel with a single iteration. It works although I'm not sure or I do not have a robust system.
    Does anyone have any suggestions that you can kindly share?
    Many thanks in advance.

  2. #2
    Registered User
    Join Date
    01-17-2018
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    4

    Re: Cumulative Sum SOS No VBA Expert

    I posted it here, thinking that only a simple macro can make everything will work and also to make up for my shortcomings deadline of running this system....

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cumulative Sum SOS No VBA Expert

    If you do that, you have no audit trail for the values summed. Why not do in in the usual way? Enter values and sum the column.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,377

    Re: Cumulative Sum SOS No VBA Expert

    Or, as a compromise, enter the values in B3 and, every time you enter a value, copy it to the next available cell in another column. You could also date and time stamp the value in the next column to give you an audit trail.

    You could clear cell B3 when you copy it so you don't have to overwrite it.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Registered User
    Join Date
    01-17-2018
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    4

    Re: Cumulative Sum SOS No VBA Expert

    Hello,
    thanks for replying. I’ve triestino with SUM and SUM IF. However since the Numbers of input per sheet is prettamente high it is not easy to handle.
    The goal is to insert i to the cell (i.e. B3) of a bell of materiale how many pieces of component A, after, with a second bill of material on the very same cell I modify A again, etc.
    After each input, in another cell I should get the sum of the whole input of A I did.
    Mano thanks

  6. #6
    Registered User
    Join Date
    01-17-2018
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    4

    Re: Cumulative Sum SOS No VBA Expert

    I tried this macro suggested to me:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    If Not Intersect(Target, Cells(3, 2)) Is Nothing Then
    Cells(13, 3) = Cells(13, 3) + Target
    End If
    Application.EnableEvents = True
    End Sub

    It works but now I have 2 questions:

    1) The nymber to be added is the result of a multiplication not of a physical input. How to solve it?
    2) How can I extend the macro to several cells on the same worksheet?

    Thanks a lot!

+ 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. Need help from expert!!
    By travis.cook21 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2015, 11:57 AM
  2. How To put Numbers in Sequence in Excel
    By sami8086 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2015, 03:47 PM
  3. Formulas for cumulative value and cumulative %
    By Brotein in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2013, 07:19 PM
  4. Not-So-Expert Excel Expert
    By HeyLucy in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-25-2013, 01:49 PM
  5. Non expert in need of help
    By jakuzi1 in forum Excel General
    Replies: 2
    Last Post: 08-18-2012, 06:17 PM
  6. Need your expert help
    By krokodilos75 in forum Excel General
    Replies: 3
    Last Post: 01-21-2009, 07:41 AM
  7. I need an expert for that!
    By mhax in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-19-2006, 09:00 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