Excel Excel SUM function always returns a zero issue.

[TinyDamooge]

Hi there,

I am trying to make a cumulative list of values, that checks against the wins/lost and add the total.
However, whatever I try the cumulative columns always return a 0.

Any idea what's up? - Below is the sheet, one in formula view and the other regular, as well as my formula settings.

Ta for any help anyone can give me.
Regards,
Luke.

 

[TinyDamooge]

Solved.

The issue was including " around the numbers in my formulae, which made Excel treat them as text. Removing the speech marks fixed it.