Count If-Unacceptable

[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

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

--
Regards

Roger Govier


"JohnHill" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>