count or sum with fixed increment

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

FAQ

Thread Tools

Display Modes

01-19-2023, 04:38 AM

Pecoflyer

Windows 10 count or sum with fixed increment

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

An option to avoid the OFFSET volatile function

Code:

=SUM(INDEX($A$1:$A$100,((ROW()-1)*4+1)):INDEX($A$1:$A$100,ROW()*4))

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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 03:56 PM.