Countif used in table

[APML]

Hi all, I'm trying to use countif in a table:

=COUNTIF(Table20[HIGH],B6)

where B6 is a separate cell (not in the table). I'm trying to count how many times the value entered in B6 (let's say .03) appears in the column in the table.
, but I'm obviously doing something wrong. Would appreciate help

 

[6StringJazzer]

Your formula is OK. I'm sure the problem is in your data. What exactly is in column HIGH? If you have a value in column HIGH, for example, 0.0312345 it will display as 0.03 but will not be counted if you have 0.03 in B6. It's not exactly 0.03.

Also sometimes real numbers that look like they should match don't. It is very unreliable to do exact matches on real numbers on a computer. Generally you should be rounding results before you try to test for equality, or test for falling within a range.

Can you describe your data in more detail, maybe explain what is in column HIGH? Are these formulas or values? Can you give examples?

 

[APML]

Your formula is OK. I'm sure the problem is in your data. What exactly is in column HIGH? If you have a value in column HIGH, for example, 0.0312345 it will display as 0.03 but will not be counted if you have 0.03 in B6. It's not exactly 0.03.

Also sometimes real numbers that look like they should match don't. It is very unreliable to do exact matches on real numbers on a computer. Generally you should be rounding results before you try to test for equality, or test for falling within a range.

Can you describe your data in more detail, maybe explain what is in column HIGH? Are these formulas or values? Can you give examples?

Hi thanks for your help, the column in the table contains numbers to 4 decimal places, and the cell I'm comparing it to also contains a number to 4 decimal places, so they are the same and formatted the same, that's why I'm confused

 

[6StringJazzer]

Are the numbers you are comparing the result of formulas?
Do the numbers actually have 4 decimal places, or are you just displaying 4 decimal places?

As I asked, can you provide examples?

I am still 99% sure that the issue is your data.

 

[APML]

Are the numbers you are comparing the result of formulas?
Do the numbers actually have 4 decimal places, or are you just displaying 4 decimal places?

As I asked, can you provide examples?

I am still 99% sure that the issue is your data.

Hi, really appreciate your help...After some internet searching i found this:

=COUNTIF(G9:G907,"="&$B$6)

So I've replaced the table column with cell addresses and it now it works.