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.

KEB9zYC.png

tOR0HXD.png

PjdJbJc.png

[Jonmo1]

Remove the quote marks from all the numbers in your formulas.

"1" is NOT a number, it's a TEXT string, and is ignored by the SUM formula
1 IS a number, and will be added in the SUM formula.

[bhenlee]

try removing the " " in your if statement..

ex: =IF(H13="Lost",1,0)

[Norie]

Lose the " around 1 and 0 in the formulas in column K and L.

Or change to using COUNTIF.

Please Login or Register  to view this content.

[TinyDamooge]

Cheers, that was exactly the problem.

All solved now thankyou.

[Jonmo1]

You're welcome.