Forum Discussion
Countif not Counting correctly
What"s wrong with my countif formula as I find 2 different answers for 2 different sheets. Attached is my file with the formula cells colored orange and the range cells colored yellow.
Liphor On the first sheet the yellow range indeed only contains 28 cells not equal to 0, compared to the 2nd sheet that 29 cells not equal to 0. The difference lies in the fact that the first sheet does not have the year 1991 in it.
By the way, you can change the formula to
=COUNTIF($N$14:$N$63,"<>0")
Oh sorry It is my oversight on the data. Technically I should be using the same number records for both sheets.