jeudi 26 février 2015

Two conflicting ways to count cells that contain any of list of words

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