COUNTIF not working
I have a list of 25 numbers in one column (range). There is one "0" in the list. In another cell when I use =COUNTIF(range, "=0"), I get a value of "1" as you would expect. HOWEVER, when I use =COUNTIF(range, "<1"), I get an output value of "0" rather than "1" which is inaccurate. This is not the only problem. For example, when I input =COUNTIFS(range, ">1", range, "<=3" I am also not getting the expected value. I have already worked with Microsoft to update Excel and when that didn't work, we reset Excel, but that did not help. From other forums I learned that I needed to make sure the cells are formatted as "General" or "Number" rather than "Text," which I have also done, but to no avail. Please advise. Thank you!
Impossible formula? Possibly COUNTIF Function
Hello, I want to create a COUNTIF formula that shows me how many Land Use Designations (LUDs) have building values less than 50% of the total property value. It is basically something like: =COUNTIF(U766:U6886, V>(.5*U)) ROW U is building value, V is total land value (land and building value combined). Does this make sense to any Excel wizards out there? Any help is very much appreciated.