Tried every which way to get rid of Value! - anyone willing to help me?

Hi Guys and Gals, Getting frustrated so hoping someone more figures/excel orientated that I might be able to help. Keep on getting the Value! sign when I'm adding up a whole load of figures adding t...