+ Reply to Thread
Results 1 to 26 of 26

R1C1 syntax

Hybrid View

  1. #1
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: R1C1 syntax

    SUMPRODUCT and COUNTIFS are not interchangeable.

    You might be able to substitute one for the other, but not without making significant changes.

    How exactly are you changing the formula?
    If posting code please use code tags, see here.

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2016
    Posts
    543

    Re: R1C1 syntax

    I just tried changing the sumproduct to countifs, as I do not know much about vba and formulas, what do you suggest. Thanks

+ 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] R1C1 Syntax issue
    By jsuarez199 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2013, 08:44 AM
  2. Updating formulas using R1C1 syntax
    By lfeder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2013, 04:06 PM
  3. Syntax to add a variable for Row Number in R1C1 format
    By Jon.R in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2011, 10:29 AM
  4. Help with Syntax Using R1C1 in VBA
    By nofzinger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2010, 11:38 AM
  5. [SOLVED] R1C1
    By Arne Hegefors in forum Excel General
    Replies: 1
    Last Post: 08-18-2006, 05:15 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