adding up results of =if

Hello -

I'm doing a spreadsheet for evaluating applications; against each criterion are three columns with check boxes for 'met', 'partially met' and 'not met', then next to those, I've used =if(c2=true,"1",if(d2=true,"0.5",if(e2=true,"0"))) to give a score for each criterion. That all works fine, but then I simply want to add up the scores at the bottom, and I can't figure out how to do that, because the usual =sum etc just gives zero

Thanks in advance

Chris

Originally Posted by chrishuning

... because the usual =sum etc just gives zero ...

That's because your formula is returning text values and not proper numbers - you should remove the quotes from the formula, like this:

=if(c2=true,1,if(d2=true,0.5,if(e2=true,0)))

but you could simplify that to:

=if(c2,1,if(d2,0.5,if(e2,0)))

or even:

=C2*1 + D2*0.5

Hope this helps.

Pete

Fabulous! Removed the inverted commas and it works.

Many thanks

Chris