countifs

G

gus

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

T. Valko

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.
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
Is there a way do to this without array formula or vlookup 1
Identical looking cells 2
Countif 2
Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
How do I match values in a sub set after a sort? 1
How to count the numbers in a Word document? 0

Top