Just enter this in B1, and copy down, or, if Column A is already filled with
data, simply *double click* on the fill handle of B1 to automatically copy
the formula in B1 down Column B, as far as there is data in Column A.

=COUNTIF(A1:A30,"Fail")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Charles Johnston" wrote in message
...
Hi

Please can anyone help me with this problem.

I have data of results of 1,000 tests either pass or fail. Data expressed
as fail fail pass pass pass pass pass pass fail pass fail etc. etc.

How can I automatically find the No of fails within a rolling 30 test sample
range?

For example how many fails between 1 and 30, and 2 and 31, and 3 and 32, and
4 and 33 and so on to the end of 1,000 tests.

Much obliged to anyone who can help.