Results 1 to 9 of 9

Help with R1C1-formula

Threaded View

torppo Help with R1C1-formula 02-06-2014, 02:18 AM
adyteo Re: Help with R1C1-formula 02-06-2014, 02:28 AM
HaHoBe Re: Help with R1C1-formula 02-06-2014, 02:33 AM
torppo Re: Help with R1C1-formula 02-06-2014, 02:47 AM
HaHoBe Re: Help with R1C1-formula 02-06-2014, 02:57 AM
torppo Re: Help with R1C1-formula 02-06-2014, 03:14 AM
torppo Re: Help with R1C1-formula 02-06-2014, 04:54 AM
djdjdj Re: Help with R1C1-formula 02-06-2014, 08:25 AM
torppo Re: Help with R1C1-formula 02-06-2014, 08:52 AM
  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    57

    Help with R1C1-formula

    Hi all,

    Am trying to write a formula to certain cells but for some reason this ain't working.
    Formula is:
    cell.FormulaR1C1 = "=if(len((RC[+2])>1);sumproduct((""huuhaa!$H$1:$H$""&lastrow=lajittelu!(RC[-5]))*(""huuhaa!$G$1:$G$""&lastrow=lajittelu!(RC[-6]))*(""huuhaa!$L$1:$L$""&lastrow=lajittelu!(RC[-1]))*(""huuhaa!$O$1:$O$""&lastrow=lajittelu!(RC[+2]))*(""huuhaa!$M$1:$M$""&lastrow));sumproduct((""huuhaa!$H$1:$H$""&lastrow=lajittelu!(RC[-5]))*(""huuhaa!$G$1:$G$""&lastrow=lajittelu!(RC[-6]))*(""huuhaa!$L$1:$L$""&lastrow=lajittelu!(RC[-1]))*(""huuhaa!$M$1:$M$""&lastrow))-sumproduct((""huuhaa!$H$1:$H$""&lastrow=lajittelu!(RC[-5]))*(""huuhaa!$G$1:$G$""&lastrow=lajittelu!(RC[-6]))*(""huuhaa!$L$1:$L$""&lastrow=lajittelu!(RC[-1]))*(""huuhaa!$O$1:$O$""&lastrow=lajittelu!(RC[+2]))*(""huuhaa!$M$1:$M$""&lastrow))"
    Yes, I know it's a "bit" long one but I don't know any other way to do this....

    Edit: Code-tags added
    Last edited by torppo; 02-06-2014 at 02:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. r1c1 formula
    By mma3824 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2012, 03:48 PM
  2. [SOLVED] Formula R1C1 Not Working
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2012, 11:00 AM
  3. [SOLVED] Need to Convert Formula R1C1 into A1-style but the Formula String exceeds 255 characters
    By VBA_Gary in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-04-2012, 12:09 PM
  4. [SOLVED] R1C1 Formula help
    By aad401 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2012, 08:45 PM
  5. Formula R1C1
    By SMILE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2010, 10:20 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