Count Crime Rubric Score

Adarian Searcy

Hi,

I am attempting to count three cells Crime Rate Score + Area Affected Score + Intangibles Score and have the overall score reflected in the Rubric Score cell. Using the following formula: =SUM([Crime Rate Score]@row, [Area Affected Score]@row, [Intangibles Score]@row)

However, after converting to a column formula the scores turn into 0.

251-400, Rubric Score = 0 is the cell "SUM" formula

251-400, Rubric Score = 44 is a manual input

Any assistance or insight is appreciated. 😃

Kelly Moore

Hey @Adarian Searcy

Try this

=VALUE([Crime Rate Score]@row)+VALUE([Area Affected Score]@row)+VALUE([Intangibles Score]@row)

I added the VALUE as I wasn't sure if you manually had formatted the column alignment to Left Justified or if the sheet defaulted the values that way. If the sheet defaulted this way, left justification indicates text values. The VALUE function will force the textstring to a numeric value.

Does this work for you
Kelly

KPH

Hi @Adarian Searcy

Does the formula work as a cell formula? You say "after converting to a column formula the scores turn into 0." Was it returning the correct value as a cell formula?

Are the values that you are summing actually numbers? If you click on the cell, you might see a ' before the number which means the number is text. If that is the issue, you can convert the text to a number using the VALUE function.

=SUM(VALUE([Crime Rate Score]@row),VALUE([Area Affected Sore]@row),….

Kelly Moore

Hey @Adarian Searcy

Try this

=VALUE([Crime Rate Score]@row)+VALUE([Area Affected Score]@row)+VALUE([Intangibles Score]@row)

I added the VALUE as I wasn't sure if you manually had formatted the column alignment to Left Justified or if the sheet defaulted the values that way. If the sheet defaulted this way, left justification indicates text values. The VALUE function will force the textstring to a numeric value.

Does this work for you
Kelly

KPH

Hi @Adarian Searcy

Does the formula work as a cell formula? You say "after converting to a column formula the scores turn into 0." Was it returning the correct value as a cell formula?

Are the values that you are summing actually numbers? If you click on the cell, you might see a ' before the number which means the number is text. If that is the issue, you can convert the text to a number using the VALUE function.

=SUM(VALUE([Crime Rate Score]@row),VALUE([Area Affected Sore]@row),….

Adarian Searcy

@Kelly Moore and @KPH

Thank you for the assistance. I was able to identify Intangibles column had 5+ as one of the issues.

The formula that worked is listed here: =SUM(VALUE([Crime Rate Score]@row), VALUE([Area Affected Score]@row), VALUE([Intangibles Score]@row)) 😁

KPH

Great news, glad we got that sorted.