Forum Discussion
Excel formula help
Hi Guys, robably very simple but i can do it... How do i copy a block of 7 rows down in 7's on excel? Example would be copying =sum(A1:A7) and making the copy come out as =sum(A8:A12) - =sum(A12:A18)...
watche87 , if your first formula is in first row, when
=SUM(INDEX(A:A,1+(ROW()-ROW($A$1))*7):INDEX(A:A,7+(ROW()-ROW($A$1))*7))
and drag in down. Sample is in attached file.
Thanks so much Sergei but i still cant make it work. So if i am putting the information onto a new sheet from a sheet called Daily2018 and block of 7 rows i want to copy would be D4:D10 what would the formula be then?
watche87 , sorry, perhaps I misunderstood you. You'd like to copy information from one sheet to another by blocks of 7 rows; or you would like to make the calculations on the blocks of 7 rows? If you could provide small sample file that helps.
SergeiBaklan So i want to copy the weekly DRINK total figure over to my new sheet to create a week on week graph of 2018 v 2019.
Please see example attached.
Thanks
