+ Reply to Thread
Results 1 to 2 of 2

Reference a dynmaic range from one cell into a countif formula

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    Eau Claire, WI
    MS-Off Ver
    2010
    Posts
    65

    Reference a dynmaic range from one cell into a countif formula

    Ok,

    So strange question. I have a series of dynamic ranges that will change based on the user input. I have a formula that matches the various criteria and concatenate the variable range. For example, it will return "$F$20:$F$34" in cell O9. I then have another formula " =COUNTIF($F$20:$F$34, ">" & R$7) that returns the count based on my request. However, I want the cell range to change based on what appears in cell O9 since that data will change. If I use =COUNTIF(O9, ">" & R$7) it obviously does not work because it does not reference the actual range, but rather the text in O9. Is there any way to do this?

    Thank you!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Reference a dynmaic range from one cell into a countif formula

    Whether this works depends upon how this was constructed: $F$20:$F$34

    Try this...

    =COUNTIF(INDIRECT(O9),">"&R$7)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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] Formula Range to reference cell value
    By Simon.xlsx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2016, 11:37 AM
  2. Select Dynmaic Range in Macro
    By ejoneslor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2016, 09:37 AM
  3. [SOLVED] countif formula changes cell values and cell reference is unchanged
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2014, 11:37 AM
  4. COUNTIF formula with reference to cell above
    By pri31 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2013, 08:07 AM
  5. Trying to put cell range reference in formula
    By corwinjk in forum Excel General
    Replies: 2
    Last Post: 05-15-2012, 06:02 PM
  6. COUNTIF formula looking for value in the cell rather than reference to that cell.
    By barksmith in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-20-2009, 09:33 AM
  7. [SOLVED] More than 1 cell reference/range in formula
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 2
    Last Post: 09-07-2005, 03:05 PM

Tags for this Thread

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