Mar 27 2019 05:50 AM
Hello,
I have a range of pollution levels that I want to compare to air quality standards. Data for the pollution level is one spreadsheet, the standards for it to be compared to are in another. I am using the following command: =COUNTIF(F6:F153,">='[Tox standards.xlsx]AEGLs'!$D$24'") but it is returning 0 when it should report all the data as exceeding the standard.
What am I doing wrong please?
Thanks.
Simon.
Mar 27 2019 06:28 AM
SolutionMar 27 2019 07:15 AM
@Sergei Baklan - that is great, thank you!
Mar 27 2019 06:28 AM
Solution