Excel Range selection

Posted on 2011-10-18
Last Modified: 2012-05-12
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.
Question by:thandel
    LVL 24

    Accepted Solution

    Like this? Change the 5 to suit:

    LVL 50

    Expert Comment

    by:barry houdini
    INDEX is often preferable to OFFSET (because it's not volatile) so with INDEX


    regards, barry

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now