Sum cells with formula

Occasional Contributor

I have built a performance tracker where an Exceed gets 1 , Meet gets 0.75 and below gets 0.40 . The issue is it will not let me sum it because the formula is read as a text 
Thie is the formula I used 

But when I do the sum it only reads the number added manually by Manager and not anything from q1-q4 .

2 Replies
best response confirmed by Xeryar (Occasional Contributor)

Remove the double quotes from your numbers in the formula.




"1", "0.75" and "0.40" are text values, not numbers. Change them to 1, 0.75 and 0.4, respectively.