+ Reply to Thread
Results 1 to 4 of 4

drag-down of indirect function does not change cell reference within " "

  1. #1
    Registered User
    Join Date
    06-28-2014
    Location
    Male
    MS-Off Ver
    2007,2010
    Posts
    15

    drag-down of indirect function does not change cell reference within " "

    Formula in B3: SUMPRODUCT(COUNTIF(INDIRECT("'"&Tabs&"'!"&"B1:T1"),B$2))

    Please help me to populate the counts for the Bravo Charlie Delta ie B4:G6
    by making the right cell reference within " " for them .
    This is basically to make the formula in B3 down to B4,B5 and B6 draggable but I cant figure it out since my countif range ie B1:T1 is within ""
    Any suggestions for a work around
    I have attached the workbook

    Thanks
    Alsan
    Attached Files Attached Files

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

    Re: drag-down of indirect function does not change cell reference within " "

    See if this solve your problem (in B3 and copy down and across)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: drag-down of indirect function does not change cell reference within " "

    Try

    in B3 : copy across and down



    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by JohnTopley; 11-14-2016 at 04:35 PM.

  4. #4
    Registered User
    Join Date
    06-28-2014
    Location
    Male
    MS-Off Ver
    2007,2010
    Posts
    15

    Re: drag-down of indirect function does not change cell reference within " "

    Thanks both José Augusto and JohnTopley ,both of your solutions are working fine

+ 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. How to update cell reference when "dragging" and INDIRECT forumla
    By mikicia in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2014, 04:48 PM
  2. If "value" then copy from "cellA" to "cellB" drag down issues
    By mrmeeks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2014, 12:34 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Circular Reference? - INDIRECT and CELL("filename") Usage
    By Nicked in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 01:20 PM
  5. [SOLVED] drag-down of indirect function does not change cell refereence between speech marks
    By nils7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2012, 04:51 AM
  6. Replies: 4
    Last Post: 10-29-2009, 12:08 PM
  7. "Indirect" reference to a cell in a code: how to do it?
    By bondcrash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2005, 12:05 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