View Single Post
 
Old 01-18-2023, 06:32 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Are you sure this is blocks of 20? The range A21:A41 has 21 cells, as does A42:A62
I will assume all blocks are 20 cells and you want the data compiled in a column starting in the first row.

Put a formula in cell H1 with this value
=SUM(OFFSET($A$1,(ROW()-1)*20,0,20,1))

Then copy this formula down for as many rows as you need.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote