What I want is in the

Then on column C: To track the 1s on columns N, AB and/or AP, You can use the query function with sum:

=SUM(QUERY(ALT_ELA!A:AP,"Select N,AB,AP where (J = '"&A10&"' or X = '"&A10&"' or AL = '"&A10&"')",0))

Note: I have tried adding 1s and names on the mentioned columns so the result in the screenshots may not be aligned with yours