Ok, it's not easy to be real clear on t hings like this, but I'll try.......
The formula is
=IF(OR(AND(COUNTA('Test Data'!AD26:AE43)<>0,COUNTA('Test
Data'!Z26:Z43)=0),COUNTA('Test Data'!AB26:AB43)=0),1,"")
First, the term COUNTA('Test Data'!AD26:AE43)<>0, means the total COUNT of
any cells within the range of AD26 through AB43 being NOT EQUAL to
ZERO.....in other words, there IS at least one cell in that range that
contains a value........likewise for the other similar versions of the COUNTA
term used in the formula.....it COUNTS the number of cells that meets it's
qualifications.
Therefore, the formula says that
IF, either of the following conditions are true,
"there is at least one cell within the range 'Test Data'!AD26:AE43 that
contains a value, AND, there are NO cells within the range 'Test
Data'!Z26:Z43 that contain any values"
OR,
"there are NO cells within the range 'Test Data'!AB26:AB43 that contain any
values",
then return the result of 1,
otherwise, return only a blank cell.
And hey, if you run into difficulty formulating the next one, just come on
back........
Vaya con Dios,
Chuck, CABGx3