Problem with INVALID DATA TYPE error with COUNTIF formula
I am trying to capture all entries where my delay (calculated using NETDAYS formula) is bigger than 50, using COUNTIF, and getting an INVALID DATA TYPE error. I tried many things, including making sure the dates used to calculate the delay ARE proper dates. I am stuck.
The strangest thing is I used to had this formula working on the same sheet, but I modified it and I can't go back to it working now.
I use a very simple: =COUNIF([Delay]:[Delay] >50)
Help Article Resources
Check out the Formula Handbook template!