computing sums

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Holden Caulfield - 11 Jul 2006 17:46 GMT

when i try to autosum a column of numbers, what im getting is the formula in
the cell and not the sum. anyone know why this is happening? thanks in
advance

Reply to this Message

Trevor Shuttleworth - 11 Jul 2006 18:08 GMT

I suspect the cell where you are putting your AutoSum is formatted as Text

Regards

Trevor

> when i try to autosum a column of numbers, what im getting is the formula
> in
> the cell and not the sum. anyone know why this is happening? thanks in
> advance

Reply to this Message

Niek Otten - 11 Jul 2006 18:09 GMT

The cell was formatted as text before the formula was entered.
Format the cell as General and re-enter the formula (F2, ENTER)

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| when i try to autosum a column of numbers, what im getting is the formula in
| the cell and not the sum. anyone know why this is happening? thanks in
| advance

Reply to this Message