+ Reply to Thread
Results 1 to 4 of 4

Increase reference by 3 columns

  1. #1
    Registered User
    Join Date
    08-17-2021
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2

    Question Increase reference by 3 columns

    Hey guys.

    I have an issue that I tried to fix for a long time.


    What I want is the reference to change every 3 columns when I autofill down the column of another table where every results shows in one page.
    =SUM(Salm_Khalaf!CA42,Haw_Lateef!CA46,Haw_A_Jabbar!CA42,Haw_Sharh!CA36,Salwa_Raju!CA18)
    =SUM(Salm_Khalaf!CD42,Haw_Lateef!CD46,Haw_A_Jabbar!CD42,Haw_Sharh!CD36,Salwa_Raju!CD18)
    =SUM(Salm_Khalaf!CG42,Haw_Lateef!CG46,Haw_A_Jabbar!CG42,Haw_Sharh!CG36,Salwa_Raju!CG18)

    What I get
    =SUM(Salm_Khalaf!CM42,Haw_Lateef!CM46,Haw_A_Jabbar!CM42,Haw_Sharh!CM36,Salwa_Raju!CM18)
    =SUM(Salm_Khalaf!CM43,Haw_Lateef!CM47,Haw_A_Jabbar!CM43,Haw_Sharh!CM37,Salwa_Raju!CM19)
    =SUM(Salm_Khalaf!CM44,Haw_Lateef!CM48,Haw_A_Jabbar!CM44,Haw_Sharh!CM38,Salwa_Raju!CM20)


    This would change everything and makes my life a thousand times easier since almost every formula on this excel file relies on increments of 3 columns.

    Thank you guys and all the best.

  2. #2
    Registered User
    Join Date
    11-02-2015
    Location
    Shetland Isles, Scotland
    MS-Off Ver
    2007
    Posts
    1

    Re: Increase reference by 3 columns

    =ROW() will give you the value of the current row, dividing by 3 will give you an increment every three rows. Use that to reference your cells using the OFFSET function.

    Googling those functions should help, sorry I don't have time just now for a detailed explanation. Happy to help l;ater today if you're still stuck.

    Jim

  3. #3
    Registered User
    Join Date
    08-17-2021
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Increase reference by 3 columns

    Yes sorry for the late reply.

    I found out how to do it thanks to this information.
    Thank you so much for your help.

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,699

    Re: Increase reference by 3 columns

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Increase in Value, Circular Reference Issue
    By Mousiefuzz in forum Excel General
    Replies: 3
    Last Post: 10-27-2015, 07:05 PM
  2. Replies: 4
    Last Post: 06-27-2012, 01:21 AM
  3. Increase Row reference when using Index
    By darknation144 in forum Excel General
    Replies: 6
    Last Post: 02-23-2012, 07:09 AM
  4. Increase Reference Rows by 7 as I Drag Down
    By a1195423 in forum Excel General
    Replies: 1
    Last Post: 08-27-2011, 04:25 PM
  5. Auto increase cell reference
    By GRAMMY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2011, 02:13 AM
  6. Replies: 3
    Last Post: 10-24-2006, 01:32 PM
  7. Text Cell reference and increase the cell reference by step value
    By Supriya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2005, 08:18 AM

Tags for this Thread

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