COUNTIFS isn't working
I am trying to count all the number of 0s within a column. I am using this formula
=COUNTIFS([Warranty Remaining]:[Warranty Remaining], 0)
but it does not work. What is weird is that, I changed the formula from [Warranty Remaining] to count a specific number in the [Warranty Obligations] column and it worked fine. I've even changed the name of the column the formula is in and I only get 0 instead of the accurate 0s in the column. The column has many 0,1,2,3,4,5,6 and I just want to count the 0s.
Thanks in advance
Help Article Resources
Check out the Formula Handbook template!