Find if any cell in range is above Zero

[paulc05]

Hi,

I have a list of data in a named range called "List". In its simplest
form the data would be cell A1:A10 that may have either a 1 or a 0
entered.

Could somebody advise how I would create a conditional formula in say
cell C1 which will tell me if any of the cells in "List" are not equal
to Zero. Something like
=if(anyValueinRange"List"<>0,"NotAllZero","AllZero")

Thanks in advance

Paul

 

[Ardus Petus]

=IF(COUNTIF(liste,"<>0")=0,"AllZero","NotAllZero")

HTH

 

[Toppers]

Blanks will NOT be counted as zeros:

=IF(COUNTIF(List,0)<>ROWS(List),"not all zeros","all zeros")

HTH

 

[carno]

if(sum(list)>0,NotAllZero,AllZero)

Since cells contain only 0 or 1