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

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

Hi!

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 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

Sort by » oldest newest most voted

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

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?

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

Or should I be using a different formula?

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

## Stats

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

Seen: 123 times

Last updated: Oct 11 '20