count or sum with fixed increment

		Microsoft Office Forums > Microsoft Excel > Excel
count or sum with fixed increment

FAQ

Thread Tools

Display Modes

01-18-2023, 05:24 PM

egit

Windows 11 count or sum with fixed increment

Office 2019

Novice

Join Date: Jan 2023

Posts: 2

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:11 AM.