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.
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
Oh sorry It is my oversight on the data. Technically I should be using the same number records for both sheets. I accidentally deleted a record.Thank You.