+ Reply to Thread
Results 1 to 3 of 3

Summing Intervals of Values

  1. #1
    Registered User
    Join Date
    08-02-2011
    Location
    IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Summing Intervals of Values

    Hi,

    I have a table containing the names of our employees and hours weekly they worked. I need to sum the hours from the 1st cell to the 21st cell, 22nd-42nd, etc.

    Solutions would greatly be appreciated thanks!
    Last edited by myoon; 08-02-2011 at 02:53 PM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Summing Intervals of Values

    There are many possibilities. Please post a sample sheet of your data, stripped from any sensitive data with " before" and "after"

    Thx

  3. #3
    Registered User
    Join Date
    08-02-2011
    Location
    IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Summing Intervals of Values

    I get data that looks exactly like this for hours from a 2 week period. I want to add everything from J2 to J20,J23 to J41, and so on. Is there some sort of automatic way I could do it besides manually doing =SUM(J2:J19)?
    Attached Files Attached Files

+ 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