Results 1 to 3 of 3

Add sumifs R1C1 formula to cell error !

Threaded View

Petter120 Add sumifs R1C1 formula to... 05-18-2012, 01:41 PM
HSV Re: Add sumifs R1C1 formula... 05-18-2012, 01:54 PM
Petter120 Re: Add sumifs R1C1 formula... 05-18-2012, 01:58 PM
  1. #1
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Kiruna
    Posts
    163

    Add sumifs R1C1 formula to cell error !

    Hi

    I am trying to add this formula to a cell but gets Runtime error 1004 does
    anyone know whats wrong with it ?

    Range("AD4").FormulaR1C1 = "=SUMIFS(R[-2]C[-25]:R[100]C[-25];R[-2]C[-29]:R[100]C[-29];RC[-2];R[-2]C[-26]:R[100]C[-26];R[-1]C)"
    Best regards

    Petter
    Last edited by Petter120; 05-18-2012 at 01:58 PM.

Thread Information

Users Browsing this Thread

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

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