Excel help

[nin9abadga]

hey all need a bit of help with excel.

i have an "if" function which works out stableford scores against par. i have the function working and returning the correct results (see the top bar for the function) but i cannot get excel to recognise the returned values and then add them up - see column I and the formula at the bottom.

so my question is, is it possible to add up those values returned by the function? or is there a way to turn the returned values into actual "numbers" so that excel recognises them?

here's a screenie to illustrate - i hope it's clear what im asking!



cheers

nin9a

 

[Haircut]

Try removing the quotation marks from around the numbers in your IF formula.

I would hazard a guess that Excel is treating them as strings and so is unable to do the sum on them.

 

[nin9abadga]

w00t it worked

thanks very much Haircut, problem solved

nin9a