+ Reply to Thread
Results 1 to 5 of 5

Summing every 2 rows in blocks

  1. #1
    Registered User
    Join Date
    08-05-2016
    Location
    Sydney
    MS-Off Ver
    2019
    Posts
    34

    Summing every 2 rows in blocks

    Hi all,

    maybe a simple problem, but can't seem to get it.
    I am trying to convert half hourly data into hourly, so I need to sum two 30min blocks to get an hourly block.
    But when I drag the formula down it counts the previous value as well.
    E.g. in the tab Hourly - cell B2 - i have input the logic to sum B2 and B3 from tab half hourly, but then when i drag that formula down it will add B3 and B4 - I would like it to add B4 and B5, and so on, i want to calculate every 2 rows without incorporating the previous row.
    Hope that makes sense.

    I have attached my spread sheet to explain.

    thanks for your help.
    Attached Files Attached Files
    Last edited by geeman86; 07-16-2017 at 04:03 AM. Reason: changed topic from counting to summing.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Summing every 2 rows in blocks

    This for D1

    Please Login or Register  to view this content.
    Kind regards
    Leo

  3. #3
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Summing every 2 rows in blocks

    Hi geeman86,

    Please try this formula in B2 and copy it down and across.

    Please Login or Register  to view this content.
    I hope this helps, please let me know!

    Regards,

    David

    If this has been helpful
    - Please click on the *Add Reputation button at the bottom left.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".


  4. #4
    Registered User
    Join Date
    08-05-2016
    Location
    Sydney
    MS-Off Ver
    2019
    Posts
    34

    Re: Summing every 2 rows in blocks

    Thanks Leo and David.
    Both methods worked fine.
    Appreciate the assistance.

  5. #5
    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,981

    Re: Summing every 2 rows in blocks

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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.

+ 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] Counting Blocks of DATA
    By mpotter20beko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-27-2016, 05:40 AM
  2. Counting occurrences not values.. Counting blocks of words in columns
    By Flydd in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-01-2016, 06:42 PM
  3. Counting blocks and continuing
    By kris18 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2015, 11:39 AM
  4. [SOLVED] Counting Blocks of Numbers
    By Omega71 in forum Excel General
    Replies: 2
    Last Post: 09-30-2012, 09:05 AM
  5. Counting blocks of data between dates
    By RichardC27 in forum Excel General
    Replies: 3
    Last Post: 01-09-2012, 10:27 AM
  6. Counting Blocks of data in a row / record
    By msommerf in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-06-2010, 12:18 PM
  7. Counting Blocks of data in a row / record
    By msommerf in forum Excel General
    Replies: 2
    Last Post: 10-06-2010, 11:04 AM

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