countifs

  • Thread starter Thread starter gus
  • Start date Start date
G

gus

Using excel - a column that have different values. how can count all the
values (valvue are numbers such; 16,17 or 18)
 
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.
 
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
 
Back
Top