countifs
 

Using excel - a column that have different values. how can count all the
values (valvue are numbers such; 16,17 or 18)

countifs
 

To count *all* the numbers and *only* the numbers in a range:

=COUNT(A1:A10)

To count specific numbers in the range:

=COUNTIF(A1:A10,16)

That will count all instances of 16 in the range.

--
Biff
Microsoft Excel MVP


"gus" wrote in message
...
Using excel - a column that have different values. how can count all the
values (valvue are numbers such; 16,17 or 18)

countifs
 

Try a pivot. Fast n easy. In the pivot wizard, in Layout, drag n drop the col
header into both the ROW and DATA areas. Set it to Count (in DATA). Click to
Finish. That's it. You're done in a matter of seconds. The pivot returns the
exact results that you're after, a listing of all the unique nums, with their
corresponding counts adjacent to it. Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"gus" wrote:
Using excel - a column that have different values. how can count all the
values (valvue are numbers such; 16,17 or 18)