Results 1 to 4 of 4

How to change drag increments.

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to change drag increments.

    I am doing a simple summation task for 70 years of data. Each year has 12 things that need to be added together.

    Is there a way I can write something like "= sum(B2:B13)", and then drag down so the boxes below look like:

    "= sum(B2:B13)"
    "= sum(B14:B25)"
    "= sum(B26:B37)"
    ...

    when I try this, excel increases every "B" by 1, I need to to increase the "b's" by 12.

    Thanks
    Last edited by DonkeyOte; 09-30-2009 at 11:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1