addinf a data list up in blocks of seven

[drag-driver]

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

 

[Dave Hawley]

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

 

[Guest]

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.

 

[Ian Mac]

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.