If I include a condition like `=if(countif(X:X,A1)>0,"found","not found")`

in an Excel formula, will Excel stop the `countif`

after it finds one matching record, or will it keep looking to find the total count in the whole column, return that count, and check if that value is `>0`

?

0

4

It works from the inside out. `COUNTIF`

returns a value, and then you are testing that value in the `IF`

. The `IF`

test is not part of the design of `COUNTIF`

, and `COUNTIF`

is not aware of what you are using the value for.

`COUNTIF(X:X, A1) > 0`

is enough – Vylix Apr 8 '17 at 3:05`=COUNTIF(X1:X10, ">0")`

Will count all cells in X1:X10 that are greater than Zero. Hence, this will yield TRUE. Then you have this`=IF(TRUE, TRUE, FALSE)`

– ejbytes Apr 8 '17 at 5:03