=IF(COUNTIF(Sheet1!A1:A10,"SAME")=10,"","NEW")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi all,

I have a formula in cells A1 to A10 which displays the
word "SAME"
under normal conditions. If the source for one of those
cells changes,
the cell will display "NEW". On a second worksheet, I
want a
single cell to display either a blank if all A1 to A10
on sheet 1 read
"SAME" or "NEW" if one or more of those cells displays
"NEW".

Confusing? Hope not. Is there a way to do this with
arrays or
similar?

Thanks.

Rob

.