Formulas not adding as numbers

Lauraarsenal

Hello, 

 

I am using the formula =IF(Status2 = [HIDE: Statuses]1, "15") to add a set percentage to a completed task when the box is checked.  It works, but then when I go to SUM those numbers, they simply combine the numbers (as though they're text) rather than adding them together (see %Complete1 and %Complete4).  How do I make the SUM formula recognize these as numbers?

 

Thanks!

 

Laura

Paul Newcome

Remove the quotes from around the 15.

Lauraarsenal

ahhh -- too easy!! Thank you so much!

 

Paul Newcome

Happy to help.