• 515K Members
• 8,700 Online
• 611K Conversations
SOLVED

New Contributor

# 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. 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.

3 Replies
Solution

# Re: Using countif across two sheets

@SimonGNCL , that's like

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

Highlighted

# Re: Using countif across two sheets

@Sergei Baklan - that is great, thank you!

# Re: Using countif across two sheets

@SimonGNCL , you are welcome

Related Conversations
COUNTIF help
brentonhobden in Excel on
3 Replies
COUNTIF not working
sme527 in Excel on
10 Replies
Separate lines on Sheets depending on condition
Mohammed Almaghi in Excel on
1 Replies
Totaling using two sets of data
dazedandconfused in Excel on
2 Replies