How to Calculate a sum between a rolling data range.
 

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.

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.

THANKS - That was the solution I was looking for!


"RagDyeR" wrote in message
...
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.

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Charles Johnston" wrote in message
...
THANKS - That was the solution I was looking for!


"RagDyeR" wrote in message
...
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.