Forum Discussion

SimonGNCL's avatar
SimonGNCL
Copper Contributor
Mar 27, 2019
Solved

Using countif across two sheets

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. ...
  • SergeiBaklan's avatar
    Mar 27, 2019

    SimonGNCL , that's like

    =COUNTIF(F6:F153,">=" & '[Tox standards.xlsx]AEGLs'!$D$24)

     

Resources