Hi,
Its a minor point but one that is bugging me.
My excel 2000 has stopped displaying the sum of cells which I select with my
mouse and has instead started displaying the count - does anyone know how to
change this back?
So for example, A1 has "10", A2 has "20" and A3 has "30". Previously, if I
had clicked on cell A1 and dragged the selection over to A2 and A3, the
window bottom right would have shown "Sum = 60". Now, however, it says "Count
Numbers = 3".
Thanks,
Will
Roger Govier - 05 Feb 2008 11:11 GMT
Hi Will
Try right clicking where you see Count, and change the Option back to Sum

Signature
Regards
Roger Govier
> Hi,
>
[quoted text clipped - 15 lines]
>
> Will
Niek Otten - 05 Feb 2008 11:14 GMT
Hi Will,
Right-click in that area and you will be offered a choice

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Hi,
|
[quoted text clipped - 12 lines]
|
| Will
will - 05 Feb 2008 16:05 GMT
Thanks both.
> Hi Will,
>
[quoted text clipped - 16 lines]
> |
> | Will