We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is it possible to add a number of rows to an offset? [closed]

asked 2017-07-27 16:19:41 +0200

naomibrown gravatar image

updated 2020-10-11 14:37:52 +0200

Alex Kemp gravatar image


I have an offset function that I'm trying to use. I have had a look at the Help documentation and had a look online, but I'm not sure how to do what I want to.

I count up the totals of E and E? in a particular range and add them together. Then I have the date and total O2 and O3 and have worked out how to use the OFFSET to do the same for P2 and P3 but don't know what to put in Q2 and Q3, R2 and R3 etc. Is there a simple way to do this? I've got about 2 years of similar data ...! C:\fakepath\Screenshot_2017-07-27_15-16-59.png

Thanks, Naomi

(edit: activated screenshot)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-10-11 14:38:02.397256

1 Answer

Sort by » oldest newest most voted

answered 2017-07-29 09:13:00 +0200

Paul451 gravatar image

What's your current OFFSET() formula? Because "rows" is the second term.

edit flag offensive delete link more


The formula I've used so far for that part, in:

O2 =K5 O3 =L4

P2 =OFFSET(K5,7,0) P3 =OFFSET(L4,7,0)

Does that help?

naomibrown gravatar imagenaomibrown ( 2017-07-31 11:21:46 +0200 )edit

Or should I be using a different formula?

naomibrown gravatar imagenaomibrown ( 2017-08-14 14:45:29 +0200 )edit

Question Tools

1 follower


Asked: 2017-07-27 16:19:41 +0200

Seen: 123 times

Last updated: Oct 11 '20