|
|
#2
01-18-2023, 06:32 PM
|
||||
|
||||
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 
|
| Tags |
| count, offset, row |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Why does the total row of my pivot table not tie to the real count using distinct count
|
wheddingsjr | Excel | 4 | 09-01-2020 09:52 PM |
| How to create a Man Hour Resource with fixed durations and fixed Work | jayreb31 | Project | 0 | 07-03-2019 01:14 PM |
|
fixed units to fixed duration
|
ketanco | Project | 1 | 11-24-2014 03:46 PM |
|
Fixed duration, fixed units, fixed work, effort driven. How, why and when use it all
|
Evgeny | Project | 3 | 01-03-2013 06:45 AM |
|
How to use fixed duration, fixed work and have resources/units leveled automatically?
|
Joeb | Project | 3 | 06-25-2012 04:18 PM |
Windows 10 
Office 2016
Threaded Mode