R SQUARED Formula Based on Conditions

[gtg430i]

Hello

I am trying to insert the R squared formula as follows:

=RSQ(Known_ys, Known_xs) ONLY if row(i)= "YES" and ignore the rest of the data. For instance, the below should calculate RSQ excluding the rows where values in column C ="NO". I tried the following formula, but it didnt work: = {IF(C1:C4="YES",RSQ(B1:B4,A1:A4),"")}

6.2	3.79	YES
7.2	4.56	NO
8.8	6.22	YES
4.5	8.9	YES

 

[maabadi]

I dont test them. try one of them with CTRL+SHIFT+ENTER

=RSQ(IF(C1:C4="YES",B1:B4,""),A1:A4)

or

=RSQ(IF(C1:C4="YES",B1:B4,""),IF(C1:C4="YES",A1:A4,""))

 

[gtg430i]

Thank you very much - This worked: =RSQ(IF($C$1:$C$4="YES",B1:B4,""),IF(C1:C4="YES",A1:A4,""))

 

[maabadi]

You're Welcome & Thanks for Feedback.