+ Reply to Thread
Results 1 to 5 of 5

Can't add up colums to give a cumulative answer with a formula, tried everything I think?

  1. #1
    Registered User
    Join Date
    08-28-2015
    Location
    hungary
    MS-Off Ver
    2013
    Posts
    14

    Can't add up colums to give a cumulative answer with a formula, tried everything I think?

    I have 3 rows: new customer ; returning customer and purchases: every month the new customer is a different number, however I want the returning customer to add up for 36 months.

    1st month: new customer+returning customer - which is 0
    2nd month: new customer+returning customer of month 1
    3rd month: new customer +r customer of month 1+2
    4th month: new customer+ rcustomer of month 1+2+3
    .....
    36th month: new customer + rcusotmer of all months added up


    here is a link how it looks like : http://s27.postimg.org/q4mt1vahf/Untitled.png

    is there a formula by which i dont have to add up all separately? thanks!!!

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,739

    Re: Can't add up colums to give a cumulative answer with a formula, tried everything I thi

    Rather than a link to an image
    Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    08-06-2015
    Location
    England
    MS-Off Ver
    2013
    Posts
    68

    Re: Can't add up colums to give a cumulative answer with a formula, tried everything I thi

    Try this
    =D9+SUM($E$9:E9)
    in E9 and apply it for the rest of your column by flash fill or copy/paste
    What this does is always add the new customer value from the row and then sum up all the values in the returning customer column from cell E9 (this is locked with the dollar sign $E$9) to whichever row you are on. So the above formula will look like this in E27: =D27+SUM($E$9:E27)

  4. #4
    Registered User
    Join Date
    08-28-2015
    Location
    hungary
    MS-Off Ver
    2013
    Posts
    14

    Re: Can't add up colums to give a cumulative answer with a formula, tried everything I thi

    here is the attachment where you can see the excel file
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-28-2015
    Location
    hungary
    MS-Off Ver
    2013
    Posts
    14

    Re: Can't add up colums to give a cumulative answer with a formula, tried everything I thi

    Thank you so much!!!!!!!!!

+ 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. How to get excel SOLVER to give out more than one answer??
    By KPee44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 04:02 PM
  2. [SOLVED] Cannot write a formula in Excel 2010 to answer query and give a final COUNTIF number
    By Kevin Fisher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2014, 04:04 PM
  3. Count, add, discriminate and give me an answer
    By LawrieAJ in forum Excel General
    Replies: 4
    Last Post: 07-13-2013, 08:24 AM
  4. [SOLVED] I need a current formula to only give me an answer if column W says DUI Help please! TY
    By LaurieLaurie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2013, 08:30 PM
  5. Row-based conditional search to give a cumulative result
    By harsh2209 in forum Excel General
    Replies: 2
    Last Post: 03-13-2010, 09:30 PM
  6. [SOLVED] How do I give different $ value to different colums in Excel?
    By Angelina G in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2006, 09:38 AM
  7. Need help with formula to give 0 if value is negative or answer is
    By Sharona77 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2006, 04:45 PM

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