I'm trying to count the number of cells in an Excel column in which any words from a list appear. I did so in two ways and got two different counts.
Method One: =COUNTIF(TableMain[Column],{"A","B","C","D","E"})
Method Two: =IF(OR(NOT(ISERROR(FIND({"A","B","C","D","E",[@Column])))),1,0)
Method Two is used in a column in the data table that places a 1 if the "Column" column contains at least one of the letters, and 0 if not. The sum of that column is 288, while Method One returns a 72.
What's going on?
Aucun commentaire:
Enregistrer un commentaire