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
 

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

Is there a way do to this without array formula or vlookup 1
Excel Need Countifs Formula Help 0
Mental block 3
Excel How to count from a column if specific condition in another column is true 3
MS Excel Function (Find Duplicate values) 3
looking for help again 1
Ideas for Grouping numeric data based on the distance from each other? 1
COUNTIF function across more than 1 column 0

Back
Top