Why are values acting like text and how do I rectify it?
My (Costing) formula was working yesterday until late in the afternoon then something happened. The formula is supposed to SUM the 'Cost' cells which have calculate the ‘material’ value (light green columns with fx) on a project. The individual cells should already be values, however these cells are acting like text.
The formula reads; =([PR1-Cost]@row + [PR2-Cost]@row + [SP-Cost]@row + [IN1-Cost]@row + [IN2-Cost]@row + [BN1-Cost]@row + [BN2-Cost]@row + [CO1-Cost]@row + [CO2-Cost]@row)
When I insert SUM at the beginning of the formula it results in $0.00
Help Article Resources
Check out the Formula Handbook template!