adding problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ntlworld - 08 Jan 2006 17:49 GMT

Dear all,
I have a problem with adding up rows of numbers.
I have "dragged" the mouse across the row of figures, then click the Autosum
icon but the row does not add up correctly. It shows as a format :-
=SUM(B1:AI1).

Is there something I am doing wrong?
Many thanks for any help.

Signature

Barry Angus
Novice

This e-mail is intended for the recipient(s) only.
All e-mails are scanned for viruses etc prior to sending.

Reply to this Message

Gord Dibben - 08 Jan 2006 20:09 GMT

It is possible that the numbers are text.

Format them to General then copy an an empty cell.

Select the numbers.

Edit>Paste Special>Add>OK>Esc.

This step should force the numbers to become numbers.

Gord Dibben MS Excel MVP

>Dear all,
>I have a problem with adding up rows of numbers.
[quoted text clipped - 4 lines]
>Is there something I am doing wrong?
>Many thanks for any help.

Reply to this Message

ntlworld - 08 Jan 2006 20:41 GMT

Hi Gord
Many thanks, with your help, I seemed to have solved the problem.

As I had originally just put numbers in the columns/rows, I did not realise
some may have been classed as text!
Again, Thanks
Barry

> It is possible that the numbers are text.
>
[quoted text clipped - 17 lines]
>>Is there something I am doing wrong?
>>Many thanks for any help.

Reply to this Message

Gord Dibben - 08 Jan 2006 20:52 GMT

Good to hear you're sorted out.

Gord

>Hi Gord
>Many thanks, with your help, I seemed to have solved the problem.
[quoted text clipped - 25 lines]
>>>Is there something I am doing wrong?
>>>Many thanks for any help.

Gord Dibben MS Excel MVP

Reply to this Message