Count If

J

JohnHill

I've got values in cells on different pages in a workbook. Let's say
that they are all in A1 across 25 different sheets. I want to count the
number of times the value in each cell is "Unacceptable" ?

Thanks in advance
 
R

Roger Govier

Hi John

I would use a helper cell on each sheet say X1 with a formula of
=--(A1="Unacceptable)

Then the answer is
=SUM(Sheet1:Sheet25!X1)
 
Top