Excell Filter

Hello everyone, I am trying to use formula correl and check correlation between two ranges in my data sheet, however this data is filtered and it has different criteria such as: Country region for ex...