Hey guys,
This one should be really easy to fix but I can't remember how I did this before.
In B12 I have the number: 49231 which changes every few days
I have the following formula in my sheet:
=COUNTIF($QJ$18:$QJ$100000,"="&QM17)
I am wanting the countif to read the number 49231 from B12 instead of the 100000
So it acts something like:
=COUNTIF($QJ$18:$QJ$49231,"="&QM17)
I've tried all sorts of things like:
=COUNTIF($QJ$18:$QJ&$B$12,"="&QM17)
=COUNTIF($QJ$18:$QJ&Value($B$12),"="&QM17)
Thanks in advance
- Hyflex
Bookmarks