+ Reply to Thread
Results 1 to 4 of 4

external cell references

  1. 01-18-2015, 02:27 AM #1
    japie3
    japie3 is offline
    Registered User
    Join Date
    10-04-2012
    Location
    Hervey Bay Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    external cell references

    Hi Everyone,

    I would like to have dynamic cell reference ie instead of having a set formula such as =countif(a1:d6,k5) have something where the cell number 1 and 6 is defined in other cells eg g1, g2.

    can anyone help?

    Thanks

    Andre
    Reply With QuoteRegister To Reply
  2. 01-18-2015, 02:32 AM #2
    ELeGault
    ELeGault is offline
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: external cell references

    Look into Indirect Formulas

    Please Login or Register  to view this content.
    I would study the syntax and logic of the statement as with any prior to real world use.

    Cheers

    EDIT - This is assuming G1 is says A1 and G2 says D6. That would then be the same as the original formula and of course can be changed there
    -If you think you are done, Start over - ELeGault
    Reply With QuoteRegister To Reply
  3. 01-18-2015, 03:23 AM #3
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: external cell references

    If you have only row number in G1 & G2 Like, 1 in G1 and 6 in G2 TRY
    =COUNTIF(INDIRECT("A"&G1&":D"&G2),K5)

    Otherwise you can try with EleGault formula
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  4. 01-18-2015, 06:54 PM #4
    japie3
    japie3 is offline
    Registered User
    Join Date
    10-04-2012
    Location
    Hervey Bay Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: external cell references

    Thanks for that, it works a treat!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I avoid having external cell references copying a tab from workbook from workbook
    By MarcoAA in forum Excel General
    Replies: 1
    Last Post: 09-10-2014, 06:50 PM
  2. Excel 2007 - Invalid Cell Reference when using Edit Links for external cell references
    By Virgil_Swan in forum Excel General
    Replies: 2
    Last Post: 08-04-2012, 11:28 AM
  3. List sorting problem with external cell references
    By bobschwenkler in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-07-2008, 03:39 PM
  4. Cell References and External Data
    By Scott in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2005, 03:24 PM
  5. [SOLVED] External References
    By Iain in forum Excel General
    Replies: 1
    Last Post: 02-03-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1