Excel Excel SUM function always returns a zero issue.

TinyDamooge

TinyDamooge

Joined
Sep 3, 2015
Messages
2
Reaction score
1
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
 
TinyDamooge

TinyDamooge

Joined
Sep 3, 2015
Messages
2
Reaction score
1
Solved.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum multiple cells based on vlookup 1
Excel Excel Macro - Variable in a formula 1
Despite formula I use (for example SUM) result is always zero. 4
A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00), 2
Can't get array formula to work in MATCH function 5
SUM formula results returns 0 value 7
Help with Excel Sum Function 3
VLOOKUP Returns a zero value 2

Top