Mar 31 2022 10:41 PM
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.
Mar 31 2022 11:15 PM - edited Mar 31 2022 11:16 PM
@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")
Mar 31 2022 11:17 PM
There is no error, please look you data carefully
If manually check in sheet Ann_RF the cells having value not equal to two value & not equal to zero is 28
The year starts from 1992 to 2019
Whereas in sheet Ann_Q the cells having value not equal to two value & not equal to zero is 29
The year starts from 1991 to 2019
Apr 01 2022 12:17 AM
Apr 01 2022 12:19 AM