+ Reply to Thread
Results 1 to 2 of 2

How to sum one number each 24 lines

  1. #1
    Registered User
    Join Date
    03-13-2015
    Location
    Lisbon
    MS-Off Ver
    Office 365
    Posts
    2

    Question How to sum one number each 24 lines

    Hi!
    I have hourly data through an entire year in columns, so in every line i have a different hour of a day. but i want to make another column to introduce the number of the day of the year that where we stand.
    It is a bit difficult to explain, so i'll try to give an example-> For 4th March, i have:
    Hour Data Number of the day
    1 67 63
    2 500 63
    3 444 63
    4 567 63
    ... ... ...
    (the last column is what i want - 4th March = 31+28+4=63th day of the year)
    So, what i want is some form of summing one day each 24 lines, so that in the Hour '1' on the 5th of March i would have 64 in the last column.

    Thank you!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello RaquelF,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Number lines disregarding blank lines
    By eloureiro in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-03-2013, 01:14 PM
  2. [SOLVED] Insert blank lines to make the total number of lines 67
    By raghuprabhu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 07:34 AM
  3. creATING NUMBER OF LINES FROM ONE NUMBER
    By rikapple in forum Excel General
    Replies: 2
    Last Post: 11-23-2007, 04:18 PM
  4. number VBA lines
    By leevi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2007, 02:43 AM
  5. Replies: 1
    Last Post: 02-03-2005, 10:06 PM

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