count selected cell using excel 2003

[alingbaba]

Hi guys,

how do i count the cells that i have selected(that contain value) using excel 2003

using 2007 is not a problem because, the selected cell which contain values are shown at the status bar at the right bottom.

THank you!

[mikezuper]

Count the number of cells that have values?

Use COUNTIF? http://www.techonthenet.com/excel/formulas/countif.php

[Pokémon]

=COUNT(A1:A10)

A1:A10 is the sample range selected.

Use COUNTA if you want alpha and numeric to be counted.

[alingbaba]

sry guys.

wat i meant was, to count the cell which i randomly select... the cell are not all in a row or colunm...

e.g. a32 c1 f45 g3 b1....i want excel to count how many cells are selected by me, this funciton is availble at excel 2007 at the bottom right status bar...it will show count:X but not on excel 2003

Yes, the cells have values.

thank you!

[quekky]

2003 only show total right? How about copy and paste into a new sheet