Used "Right" formula to put data in a range of cells then used SUM to add the data of that range.

Shajan

I Used "Right" formula to put data in a range of cells then used "SUM" to add the data of that range.

I don't receive a valid number in the cell. The formula returns "0"

Above is the formula that pulls the data from the original cell to give me a number.

Above is the formula that I am using to try to calculate the sum of the range. All I did was use the "Formula" button and choose "Sum" and selected the range. But it just returns 0.

That's the whole sheet.

William Meixner

RIGHT() is a text command, so the return from this function is text. You would need to wrap that in VALUE() to convert the text output from RIGHT() into numeric, allowing then for SUM().

Example:

=VALUE(RIGHT([Project Cost Score]@row,1))

Jeff Reisman

The reason this isn't working is because RIGHT is a text function, and SUM is a number function. RIGHT is pulling your numbers from the Project Cost column as text values, which SUM cannot add.

You could try wrapping the RIGHT formula inside a VALUE function, which should change it back to integer values.

=VALUE(RIGHT([Project Cost]@row, 1))

Provided your other column values are integers, your SUM formula should then work.

William Meixner

RIGHT() is a text command, so the return from this function is text. You would need to wrap that in VALUE() to convert the text output from RIGHT() into numeric, allowing then for SUM().

Example:

=VALUE(RIGHT([Project Cost Score]@row,1))

Jeff Reisman

The reason this isn't working is because RIGHT is a text function, and SUM is a number function. RIGHT is pulling your numbers from the Project Cost column as text values, which SUM cannot add.

You could try wrapping the RIGHT formula inside a VALUE function, which should change it back to integer values.

=VALUE(RIGHT([Project Cost]@row, 1))

Provided your other column values are integers, your SUM formula should then work.

Shajan

@William Meixner and @Jeff Reisman Thanks your your comments - my form now works.