+ Reply to Thread
Results 1 to 4 of 4

Copying doesn't work!

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    Netherlands
    MS-Off Ver
    2003 and 2010
    Posts
    2

    Question Copying doesn't work!

    I have the formule:

    =IF(ISNUMBER($Q42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($R42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($S42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($T42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($U42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($V42);SUM('Opslag grafiek'!C$125:C$172);0))))))
    I need to copy this formula down, and I would like the bold numbers and letters count.
    i want the C in the next box become a D and 42 become 43.
    I only get the 42 to 43 but the C wont go to D.

    Is there a way to do this?

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copying doesn't work!

    you can shorten that a bit then
    IF(COUNT($Q42:$U42);SUM(INDEX('Opslag grafiek'!$C:$XFD;113;ROWS($1:1)):INDEX('Opslag grafiek'!$C:$XFD;268;ROWS($1:1)));IF(ISNUMBER($V42);SUM(INDEX($C:$XFD;125;ROWS($1:1)):INDEX($C:$XFD;172;ROWS($1:1)));0))
    should work
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    08-06-2014
    Location
    Netherlands
    MS-Off Ver
    2003 and 2010
    Posts
    2

    Re: Copying doesn't work!

    Thanks a lot!

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copying doesn't work!

    i had a rethink and can shorten that even more
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    i also noticed i missed the sheet references in the second part of the previous post

+ 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] Copying filtered table doesn't work as it is expected in Excel 2010
    By abbassi in forum Excel General
    Replies: 2
    Last Post: 06-29-2014, 01:57 AM
  2. [SOLVED] Macro work in personal workbook, doesn't work in other workbooks
    By Centexcel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2013, 11:47 AM
  3. [SOLVED] Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-27-2013, 11:55 AM
  4. Copying a webpage - it doesn´t work as just fractions get copied
    By brecki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2012, 05:26 PM
  5. Copying and pasting formulas doesn't work!!
    By Bill-E-BoB in forum Excel General
    Replies: 6
    Last Post: 03-13-2007, 10:01 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