How to combine SUMIFS and COUNTA?

[kyber]

Maybe I'm using the wrong formulas.

But, the idea is for F16 to tally up all "No's" from Columns J and K and correspond the total to the individuals. Next, in the same cell, I need it to count if anything is written in Column L and add it to the tally corresponding the respective individual.

My current attempt of the formula is: =IF(a16="","",SUMIFS(Table1[Individual],Table1[[Column10]:[Column11]],D29)+COUNTA(Table1[Column12]], a16))