Summing rather than Countinh when selecting cells

  • Thread starter Thread starter will
  • Start date Start date
W

will

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
 
Hi Will
Try right clicking where you see Count, and change the Option back to Sum
 
Hi Will,

Right-click in that area and you will be offered a choice

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
Back
Top