Ask Your Question

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

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

naomibrown 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 retag flag offensive close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 65 times

Last updated: Jul 29 '17