COUNT where cells value = to "value"

  • Thread starter Thread starter Darren \(at work\)
  • Start date Start date
D

Darren \(at work\)

Hi,
I have a column in a spreadsheet into which can be one of a number of
values. e.g:

Scratch
Paint Fault
Inclusion
etc......

What need to do is to count the number of times that each of these values
appears in this column and display that value in another cell. e.g:

| TOTAL
Scratches | 6
Paint Fault | 10
etc.....

Any tips or pointers greatly appreciated

Regards
Darren
 
Darren,

You should have a title row above your data. Select your cells (including
the title row), then use Data | Pivot Table... , create the pivot table, and
then when the Pivot Table Toolbar appears, drag the button with the title
row value to both the row and data areas of the pivot table, and you'll get
both a list and a count of appearances.

HTH,
Bernie
MS Excel MVP
 
Hi
one way:
=COUNTIF($A41:$A$100;"Scratch")

another way could be to use a pivot table to count the number of
occurences
 
Assuming your list is in A5:A100, I'd list each value you're looking for in
a column on the other sheet, then ...

=COUNTIF($A$1:$A$100,A15)

Where A15 is a cell on the other sheet that has the value you're counting in
the list (e.g., A15 = Scratch)

You can also click somewhere in your list and use either the Subtotals
command or the PivotTable feature to come up with the counts automatically.
Both commands are in the Data menu.
--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
Darren,

=COUNTIF($A$1:$A$100,"Scratches")

or if the value is in a cell, use

=COUNTIF($A$1:$A$100,H1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top