Hi all,

I am trying to evaluate correlation between two columns with:
- 1 criteria on first column
- 1 criteria on second column
- 1 criteria depending on another column

Example below:
2019-05-06_14-52-57.jpg

I want to use correl function for question 1 and question 2, keeping only values of question 1 and 2 below 11 and non null + only rows with "France" in column H.

I tried several options but did not manage to make it work with all 3 criteria. For instance, it is working with two criterias (below 11 for Q1 and below 11 for Q2) using this: =CORREL(IF(F2:F8<11;F2:F8;"");IF(G2:G8<11;G2:G8;""))

Thank you a lot for your help!