addinf a data list up in blocks of seven
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: addinf a data list up in blocks of seven

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a colum which contains numbers. I want to sum this list up in blocks of 7. I need a formulae which i can just fill down so that it will do it automaticaly.

    [ This Message was edited by: drag-driver on 2002-03-04 03:20 ]

    [ This Message was edited by: drag-driver on 2002-03-04 03:20 ]

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Drag-Driver

    There are a few ways this could be done here is but 1. They both assume your numbers are in column "A"

    in Cell B8 put = SUM(A1:A7) now select cells B8:B15 and drag down by the fill handle of cell B15 (small black square ) to one cell past the last cell in Column A




  3. #3
    Guest

    Default

    On 2002-03-04 03:19, drag-driver wrote:
    I have a colum which contains numbers. I want to sum this list up in blocks of 7. I need a formulae which i can just fill down so that it will do it automaticaly.
    Hi drag-driver,

    assuming your no's start in a1 going down
    put:

    =IF(ISERR(FIND(".",COUNT(A$1:A7)/7)),SUM(OFFSET(A7,-6,0):A7),"")

    in b1

    Any probs let me know.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Sorry that forula I put above should be:

    =IF(ISERR(FIND(".",COUNT(A$1:A1)/7)),SUM(OFFSET(A1,-6,0):A1),"")

    in B1. I lifted copied the last one from cel B7 instead of B1.

    by the way I can't of the life of me think of how to tidy up the arguement part of the IF() statement, but it works for me.


    "Have a good time......all the time"
    Ian Mac

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com