|
|
#1
01-18-2023, 05:24 PM
|
|||
|
|||
count or sum with fixed increment
Hello,
I have a large table of more than 2000 rows, and 5 columns. The values of these cells are either 1 or 0. For each column I want to be able to count the number of 1s in blocks of 20 rows starting from the first row. Example: For each column count the number of 1s in the first 20 cells (A1:A20), then in cells 21 to 41 (A21:A41), then from 42 to 62 and so on. Any help is appreciated. Many thanks, egit 
|
| 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 11 
Office 2019
Threaded Mode