Don't do (formula) if all cells are blank

[alinpion]

I need a formula that will not execute if ALL cells " A1:A5 " are blank
The formula works with cells from another sheet:

This is my formula:

=IF(NOT(ISBLANK(data!A1:A5)); COUNTIF(data!A1:A5; "=0") ; " ") and is NOT WORKING

the formula works if is just one cell "A1"

=IF(NOT(ISBLANK(data!A1)); COUNTIF(data!A1:A5; "=0") ; " ")

 

[Sektor]

= IF(SUM(data!A1:A5)=0,"",COUNTIF(data!A1:A5,"=0"))

 

[Desu Nota from Columbus]

=IF(AND(A1="",A2="",A3="",A4="",A5=""),"",COUNTIF(data!A1:A5; "=0"))

Try this.

 

[Andrew Poulsom]

For me:

=COUNTIF(data!A1:A5,"=0")

ignores blank cells (Excel 2003).

 

[alinpion]

For me:

=COUNTIF(data!A1:A5,"=0")

ignores blank cells (Excel 2003).

If all cells are blank I want this formula =COUNTIF(data!A1:A5,"=0") to return " " (blank cell) not 0

In this form =COUNTIF(data!A1:A5,"=0"), when all cells are blank , returns 0 and I want the formula to return " " blank cell .

 

[Yahya]

Try this
=IF(COUNT(A1:A5),COUNTIF(A1:A5,"=0"),"")

 

[alinpion]

Try this
=IF(COUNT(A1:A5),COUNTIF(A1:A5,"=0"),"")

cells A1:A5 are in different sheet then formula, the sheet name is "data"

 

[Desu Nota from Columbus]

=IF(AND('Data'!A1="",'Data'!A2="",'Data'!A3="",'Data'!A4="",'Data'!A5=""),"",COUNTIF(data!A1:A5; "=0"))

 

[Yahya]

Ok
try this
=IF(COUNT(Data!A1:A5),COUNTIF(Data!A1:A5,"=0"),"")

 

[Andrew Poulsom]

How about?

=IF(COUNTBLANK(data!A1:A5)=ROWS(data!A1:A5),"",COUNTIF(data!A1:A5,"=0"))