+ Reply to Thread
Results 1 to 6 of 6

Moving the columns halfway

  1. #1
    Registered User
    Join Date
    07-28-2016
    Location
    Chatham
    MS-Off Ver
    2016
    Posts
    91

    Moving the columns halfway

    That was a very bad explanation...

    I have the following formula in A1:

    =IF(AND(PQQ!E28="Fail",ITT!E24="Fail"),"Fail",SUM(D4:D8))

    When I drag it to the right (A2 and so on), I need it to change to =IF(AND(PQQ!G28="Fail",ITT!G24="Fail"),"Fail",SUM(E4:D8)) - hence the SUM bit just goes by 1 column to the right as normal. But the AND bit goes by 2 columns - from E to G.

    I know there is some king of COLUMN formula but not sure how to write it down here.

    Would be grateful for the advice.

    Thank you.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Moving the columns halfway

    =IF(AND(PQQ!E28="Fail",ITT!E24="Fail"),"Fail",SUM(D4:D8))
    =IF(AND(PQQ!G28="Fail",ITT!G24="Fail"),"Fail",SUM(E4:D8))

    What exactly is in those SUM columns?
    Did you notice that your adjusted SUM range went to E4:D8? Was rgar supposed to be E4:E8 or D4:D8?
    What headings do those columns have?
    Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Moving the columns halfway

    I suppose you want this

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Copy to forward (for other columns)

    See the file
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-28-2016
    Location
    Chatham
    MS-Off Ver
    2016
    Posts
    91

    Re: Moving the columns halfway

    Sorry for a late reply due to weekend.

    Thank you Jose, that is exactly what was needed!

    Sorry FD for not coming back and clarifying, the SUM formula should have just moved by one column as usual, hence would have been E4:E8. But Jose has helped with the right formula.

    Thank you all once again!

  5. #5
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Moving the columns halfway

    You are welcome.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Moving the columns halfway

    Thanks for the feedback

+ 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. Sequential events stopping halfway...
    By Bigjet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2015, 09:47 AM
  2. Macro for vlookup (halfway there)....
    By leswes14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2013, 01:29 PM
  3. Nested If statement Help! halfway got it figured out
    By T_BOLT in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2013, 02:41 AM
  4. excel program giving up halfway through calculation
    By Nikolai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2008, 01:54 PM
  5. Formula works halfway?
    By hottxboi16 in forum Excel General
    Replies: 1
    Last Post: 10-25-2006, 11:15 AM
  6. [SOLVED] Macro running halfway only
    By Joe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2006, 01:55 PM
  7. if month is less than halfway over subtract 1
    By coal_miner in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2005, 11:06 AM

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