Results 1 to 4 of 4

Thread: How to make the count if a dynamic variable

  1. #1

    How to make the count if a dynamic variable



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am using the countif function and I am not able to make the "IF" part a dynmaic variable. Is there a way to do this.


    Variable 200
    345
    123
    234
    456
    567

    I am using a formula like this: =countif(A3:A7,">=200")
    I would like for it to be something like this =countif(A3:A7,">=$B$1")

    For some reason when I try the second one it breaks the formula, but any other combination doesn't seem to be working either.

    Any help would be AWESOME! Thank you in advance.

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,462
    Articles
    0
    Excel Version
    2010 on Xubuntu
    You're not that far away
    Try =countif(A3:A7,">="&$B$1)

    ">=$B$1" makes the entire formula text so XL does not recognize it

  3. #3
    Try =countif(A3:A7,">="&$B$1)

    That didn't work. After the ".." it ends the formula

  4. #4
    You were write. When I copied the formula I didn't add the "&"! Thank you!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •