+ Reply to Thread
Results 1 to 2 of 2

how to stop cells from counting by more than 1 when dragging a series

  1. #1
    Registered User
    Join Date
    08-27-2016
    Location
    San Diego
    MS-Off Ver
    2016
    Posts
    6

    how to stop cells from counting by more than 1 when dragging a series

    This may be hard to explain, but here goes nothing.
    I have a spreadsheet with several tabs that link to each other. On the main sheet I am trying to make it such that when I drag the template cells down, they only count up by 1 for a certain formula that is linked to another sheet, but increase by 9 for the rest of the formulas.
    For example:
    In D15, I have =IF(A6="", "", A15-$H$2), then when I drag it, it becomes =IF(A15="", "", A24-$H$2).
    But in D18, I have =IF(Observations!H5="","", Observations!H5) and when I drag that one, I only want it to increase by 1, but it always counts up by 9 becoming =IF(Observations!H14="","", Observations!H14).
    I understand that it's counting up by that many because of the number of cells I am dragging it, but is there a way to increase all the other formulas by 9 and have this one formula only increase by 1?

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: how to stop cells from counting by more than 1 when dragging a series

    It may help someone understand the issue if we could see a sample. Directions for uploading a sample workbook are given in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Stop Countif from counting blank cells
    By acmac1962 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2019, 03:52 AM
  2. VBA string for dragging data to last blank row in a series of blank cells in a column
    By JDGRN5008 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2019, 02:42 PM
  3. Replies: 9
    Last Post: 01-19-2018, 03:57 AM
  4. Stop Dragging over Formulas
    By Justin123456 in forum Excel General
    Replies: 1
    Last Post: 05-24-2017, 04:23 PM
  5. [SOLVED] Dragging down linked cells as a series
    By Jbelle7435 in forum Excel General
    Replies: 5
    Last Post: 07-05-2016, 04:50 PM
  6. Replies: 9
    Last Post: 08-17-2015, 04:05 PM
  7. Problem with series counting empty cells
    By confused_novice in forum Excel General
    Replies: 2
    Last Post: 05-02-2007, 12:35 PM

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