"S.H.C" wrote
..... ( Backgrd in: http://tinyurl.com/6sec3 )
Using the same sheet and having the same effect
I just need more testing of the other cells
in R,S,T collums they are merged in every row and in this box
it needs to be atleast 5, and in Coullum AC
it also needs to be atleast 5. So using the same formula
is there a way to put these other tests in also?

Yes, think we just need amend the formula in AP5 (in sheet: week #1) to test
for the additional tests / criteria. The existing formulas in sheet:
Lianhona #1 remain unchanged.

Option A: If, as you say, cols R,S,T *are* merged in every row
(what this means is that R5:T5 are presumed merged into one cell, R6:T6 are
also merged, and so on, down cols R,S,T. If this is the case, then only the
leftmost cells of each merged part, i.e. R5, R6, R7 etc will remain)

In sheet: week #1
------------------
Put in AP5:
=IF(OR(R5="",AC5="",AN5=""),"",IF(AND(R5=5,AC5=5 ,AN514),ROW(),""))
Copy AP5 down to say, AP1000 as before

Option B: If, however, cols R,S,T are *not* merged in every row
and you want the tests that the values in each cell in cols R, S, T has to
be at least 5, then try the formula below

In sheet: week #1
------------------
Put in AP5:
=IF(OR(R5="",S5="",T5="",AC5="",AN5=""),"",IF(AND( R5=5,S5=5,T5=5,AC5=5,A
N514),ROW(),""))
Copy AP5 down to say, AP1000 as before

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----