+ Reply to Thread
Results 1 to 2 of 2

Find sums of three repeating values

Hybrid View

juliorevka Find sums of three repeating... 02-14-2012, 04:43 PM
martindwilson Re: Find sums of three... 02-14-2012, 06:24 PM
  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    NYC, US
    MS-Off Ver
    Excel 2010
    Posts
    19

    Find sums of three repeating values

    I need to find the sums of sets of three values that repeat every 6, then place these sums onto a new column (M).

    For example,
    M2 = F3 + F9 + F153
    M3 = F21 + F27 + F33
    M4 = F41 + F47 + F53


    The above is all I currently need, don't feel discouraged of answering because of the long bottom part (I've noticed that longer questions are less likely to be answered). What's below isn't crucial, but if you're willing to help...

    ===============================================================================
    The real challenge is that after row 1400, I added a new line item. Therefore, the pattern becomes 7 then 6.

    For example,

    M = F1403 + F1410 + F1416.

    It would be awesome if you could just help me with the first part, so I could think of a way to tackle the second part. If this helps, I can shed some light on what I am doing (maybe summing by rows is the totally wrong approach):

    I have three types of accounts (1,2, and 3), 102 fiscal months, and 8 types of fees associated with a Item Count. I need to sum the monthly cost associated with each type of fee (meaning I need to sum the three accounts per month).
    For example, to find the total monthly cost of fee type 2 during July 2003, I need to add up:
    Account 1 , Fee Type 2 = 3900
    Account 2, Fee Type 2 = 200
    Account 3 Fee Type 2 = 100
    Which results in 4,200 items in July 2003.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Find sums of three repeating values

    I dont understand the pattern ,there isnt one!
    should this
    M2 = F3 + F9 + F153
    M3 = F21 + F27 + F33
    M4 = F41 + F47 + F53
    be
    M2 = F3 + F9 + F15
    M3 = F21 + F27 + F33
    M4 = F39 + F45 + F51
    if so in m2 put
    =SUM(INDEX(F:F,(ROWS($A$1:A1)*18)-15),INDEX(F:F,(ROWS($A$1:A1)*18)-9),INDEX(F:F,(ROWS($A$1:A1)*18)-3))
    Last edited by martindwilson; 02-14-2012 at 06:36 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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