# Thread: How to make the count if a dynamic variable

1. ## How to make the count if a dynamic variable

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.  Reply With Quote

2. 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  Reply With Quote

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

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

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

#### Tags for this Thread

countif #### Posting Permissions

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