Results 1 to 5 of 5

Sum of variable number of rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2008
    Location
    Western Australia
    Posts
    19

    Sum of variable number of rows

    G'day All,

    I reckon this should be easier than I'm finding it, but I just can't seem to find the right combination of functions to solve this.

    In column A I will have an entry every 5 or 6 or 7 rows with blanks rows between.
    In Column B starting at every row corresponding with an entry in Column A there will be a short column of figures could be 1 2 3 or four or more of them. (the're will always be a blank between the last number in a group in B before the next entry in A)
    In column C starting at every Row corresponding to an entry in column A I want the sum of the group of figures in Column B.

    But here's the rub.... The most important thing is that I can use the same formula all the way down column C. So click the one formula at the top and drag it all the way down 1000 rows.

    I know this is easy for those with a bigger brain than mine.... but I'm stumped!
    Attached Files Attached Files
    Last edited by Aussie-Clive; 08-07-2009 at 02:37 AM.

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