Adding 5 variables when 2 variables are null , in this total value not showing?

This is how i have i would have done:

Reference xlsform:

BSC_Share.xlsx (96.1 KB)