More issues with Summing the Squares in Noncongruous columns

[ChemistB]

Just when I think I think I have it figured out, (see
http://www.excelforum.com/excel-form...-variable.html
and
http://www.excelforum.com/excel-form...d-per-row.html

I run into a situation that I can't figure out. In this case, I need to calculate the sums of the squares of each row for each column PLUS the last column. So, for column 1 calc
Row 2 =( Count in Col 1 and 6 ="A") ^2 + (Count in Col 1 and 6 of "R")^2
Row 3 =( Count in Col 1 and 6 ="A" )^2 + (Count in Col 1 and 6 of "R")^2
and so on,
I want the SUM of rows2:20.
The MMult equations I was using previously do not work because the two columns (1 and 6) are not congruous.
So, it is the value in H21 that I would like to be able to attain directly with a formula.

[shg]

Maybe ...

=SUM(MMULT(--(CHOOSE({1,2}, A2:A20, F2:F20)="A"),{1;1})^2)
+SUM(MMULT(--(CHOOSE({1,2}, A2:A20, F2:F20)="R"),{1;1})^2)

[ChemistB]

Maybe

Works great SHG. Thanks

[shg]

You're welcome, CB.