[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Excel Range selection

Posted on 2011-10-18
Medium Priority
237 Views
I have a formula: =SUM(B90:M90).... however what I would like to do is specify how many columns to move over starting at B90 in row B.  For example the range might be B90:D90 or B90:H90.

How can I "count" over a certain number of columns from a given starting column point in the range selection of the SUM function?

Thank you.
0
Question by:thandel

LVL 24

Accepted Solution

StephenJR earned 2000 total points
ID: 36988659
Like this? Change the 5 to suit:

=sum(offset(B90,0,0,1,5))
0

LVL 50

Expert Comment

ID: 36988734
INDEX is often preferable to OFFSET (because it's not volatile) so with INDEX

=SUM(B90,INDEX(B90:M90,5))

regards, barry
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month18 days, left to enroll