Results 1 to 3 of 3

Sum cells in a range based between two equal cell values in another range

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Sum cells in a range based between two equal cell values in another range

    I have three columns of data. The first is criteria that I am using to decide which cells to add in the other two cells as follows...

    0 0 348
    1 277 0
    1 0 32
    3 0 5
    4 104 0
    4 41 0
    3 0 199
    4 299 0
    4 108 0
    4 6 0

    My problem is when I come to the first 3 I need to sum all other rows until I hit the next 3. Any help would be great. I have tried several versions of sumproduct and sumif but can not get it to work. I have attached clear sample data.
    Attached Files Attached Files
    Last edited by sshone1; 07-08-2013 at 10:37 PM.

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