Count If
 

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


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=549338

Count If
 

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)

--
Regards

Roger Govier


"JohnHill" wrote
in message ...

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


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile:
http://www.excelforum.com/member.php...o&userid=25171
View this thread:
http://www.excelforum.com/showthread...hreadid=549338