AUTOSUM DOESN'T ADD UP CONVERTED VALUES

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

I've used the FIXED function to round some values to 2
decimal places. I understand that the values are now
recognised as text.

The Autosum function does not add them up but I can add
them using =b2+b3+b4 etc.

Is there any way that I can add them automatically using
autosum? There are over 200 cells to calculate and it's
impractical to add them individually


Thanks

Diane
 
Diane said:
I've used the FIXED function to round some values to 2
decimal places. I understand that the values are now
recognised as text.

The Autosum function does not add them up but I can add
them using =b2+b3+b4 etc.

Is there any way that I can add them automatically using
autosum? There are over 200 cells to calculate and it's
impractical to add them individually


Thanks

Diane
Click to expand...

Why did you use FIXED, which returns a result as text? You should have used
ROUND, which returns a number. If you still have the originals, I suggest
you go back and do this now. Otherwise, to convert the text results back to
numbers, try this:
Copy a blank cell (formatted as General or Number but NOT text).
Select the cells containing the 'numbers' in text format.
Use Edit > Paste Special > Operation, Add > OK
 
Diane

You could use =SUM(VALUE(range)) and enter it as an array formula (Ctrl
Shift and Enter). You'd be better off making the numbers back into numbers,
though. Copy an unused cell (not formatted as text), select your cells and
use Paste/Special/Add.

Andy
 
Autosum does not recognise text values. You could try
converting the text value to numeric. The text could be
converted by enetering 1 in a separate cell copy that and
select the range of data and chose paste special and check
multiply.
 
Back
Top