<tbody>
=SUMIF($A$1:$A$47,"=4",C1:C47) --> This was my simple formula before. Simply sum C1 to C47 if A1 to A47 contain 4.
=SUMIF($A$1:$A$47,"=4",AND N53="YES",C1:C47 ---> Now I want to add an "AND/IF" C53="YES" (If C53 = "NO", return 0)
=SUMifs((A1:A47,"=4")*(C53="yes")*C1:C47,0)...