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))

[JohnTopley]

Try

=IF(A16="","",SUMPRODUCT((Table1[Individual]=A16)*(Table1[[Column10]:[Column11]]=$D$29))+COUNTIFS(Table1[Column12],"<>",Table1[Individual],A16))

You need to study how COUNTA works: it does not work by comparing with another cell you have in your formula.

D29 contains "NO" !

[kyber]

It works, thank you!