• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countif and Tables

O

Oh help

New Member
My problem is I have table - I've simplified it below to one column. When I write a formula using structured references ie =COUNTIF(table123[@[The column]],"A") it produces the result 1 rather than 2. When I wrote =COUNTIF(Sheet1!$A$2:$A$6,"A") I get the correct result

What am I doing wrong and what have I misunderstood as I cant see why the 2 formulas produce different results

Thanks in advance

The column
A
B
A
B
C
 
If you are presenting the formula on the same sheet then you do not need to ref the table name, ie. =COUNTIF([The column],"A").
However if you are placing the formula on a different sheet then =COUNTIF(Table1[[#All],[The column]],"A")
 
You must log in or register to reply here.
Back
Top