+ Reply to Thread
Results 1 to 5 of 5

Formula for accumulating values of numbers in varied location

  1. #1
    Registered User
    Join Date
    03-07-2015
    Location
    Skadoosh Town
    MS-Off Ver
    2010
    Posts
    2

    Question Formula for accumulating values of numbers in varied location

    Hi Guys,

    I need help identifying the correct formula to use for this Excel Spreadsheet.

    What formula can I use so that every time there is a "1" in the cell, Excel accumulates the corresponding "Total" value?

    For example, In column "B1" the number "1" is present 6 times, and the corresponding "totals" are as follows "7+4+3+3+4+5" - How can i make it so Excel does this automatically. It is okay when you have a small amount of rows, but I have upwards of 400!

    It is the TOTAL of the accumulated values that I am interested in (e.g 7+4+3+3+4+5 = 26)

    I have attached a photo reference of my spreadsheet - Excel Help.png

    I hope that I have explained my problem clearly here, any help would be greatly appreciated!

    Thanks in advance!!

  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 for accumulating values of numbers in varied location

    I think you want something like this...

    Data Range
    A
    B
    C
    D
    1
    1
    7
    22
    2
    1
    6
    3
    5
    4
    4
    5
    1
    4
    6
    5
    7
    1
    3
    8
    3
    9
    1
    2
    10
    ------
    ------
    ------
    ------


    This formula entered in D1:

    =SUMIF(A1:A10,1,B1:B10)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Formula for accumulating values of numbers in varied location

    try..

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    adjust as per requirement..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  4. #4
    Registered User
    Join Date
    03-07-2015
    Location
    Skadoosh Town
    MS-Off Ver
    2010
    Posts
    2

    Re: Formula for accumulating values of numbers in varied location

    This works from what I can see so far through testing! Thank you so very much for your help, you've saved me a tonne of time and effort!!

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

    Re: Formula for accumulating values of numbers in varied location

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

+ 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. Accumulating values in a single cell.
    By jaganexcel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-23-2013, 05:38 AM
  2. [SOLVED] If Function with multiple outcomes and accumulating numbers
    By Brainstorm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2012, 07:04 PM
  3. Deleting brackets and numbers of varied length.
    By Yappa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2008, 08:41 AM
  4. [SOLVED] accumulating values generated daily
    By Tracey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2006, 03:15 AM
  5. Accumulating Values in a Pivot table
    By Kurt in forum Excel General
    Replies: 2
    Last Post: 03-02-2005, 05:06 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