Count based on criteria.

One way is to do something like this:

=COUNTIFS(Table 1::M,A2,Table 1::Q,"Yes",Table 1::R,"Yes",Table 1::S,"Yes",Table 1::T,"yes",Table 1::U,"Yes",Table 1::V,"Yes")

Your table already has an unwieldy number of columns, but another approach would be to add a column with a formula in it to test for 6 'Yes' and in the second table use SUMIFS on that column.

In column X:

=IF(COUNTIF(Q2:W2,"Yes")=6,TRUE,FALSE)

In Table 2:

COUNTIFS(Table 1::M,A2,Table 1::X,TRUE)

More on COUNTIFS here:

COUNTIFS - Apple Support

Replace the , in the formula with ; if your region uses , as the decimal separator.

SG