Hi

In J3

=SUMIF($D$2:I$2,"Successful",$D3:I3)

In K3

=SUMIF($D$2:J$2,"Total",$D3:J3)

I would suggest you to bring the Successful Total and Overall Total columns into Col D & E, so that the formula can be made dynamic.

In that case the formula would be

=SUMIF($F$2:AA$2,"Successful",$F3:AA3)

=SUMIF($F$2:AA$2,"Total",$F3:AA3)

Replace the highlighted AA with appropriate end column reference.