COUNT where cells value = to "value"

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
 
B

Bernie Deitrick

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
 
F

Frank Kabel

Hi
one way:
=COUNTIF($A41:$A$100;"Scratch")

another way could be to use a pivot table to count the number of
occurences
 
R

Robert Rosenberg

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
 
B

Bob Phillips

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)
 
Top