Using the IF

[Novman]

Sorry I don't have a copy to post just now but looking for help for the following if possible if not I'll try get a post up with table,
I have a few sheets taking data to my last sheet, IE
(A4) Spoons needed (B4) 6
(A5) Plates needed (B5) 10
(A6) Cups needed (B6) 0
And so on, what I am doing is using the =sheet1 A4 to show on sheet4 what is in that cell and same with B4 returning spoons needed one cell and other returning 6.
What I want to do is add, if their is no spoons need as figure is 0 then in do not show spoons in my sheet4,
If theses does not make sense please say and I'll try as soon as to get a post of what I'm looking for to make it easier,

 

[etaf]

how about
=IF(COUNTIF(Sheet1!$A$4:$A$100,0)>0,"",Sheet1!A4)

so if it finds a zero in the list then the all the cells on sheet4 will be blank
sheet1 with no zeros

Book1
	A	B
2
3
4	6
5	10
6	1
Sheet1

sheet 4 result

Book1
	A	B
1
2
3
4		6
5		10
6		1
Sheet4

Cell Formulas
Range	Formula
B4:B6	B4	=IF(COUNTIF(Sheet1!$A$4:$A$100,0)>0,"",Sheet1!A4)

Sheet1 with a zero

Book1
	A	B
1
2
3
4	6
5	10
6	0
Sheet1

sheet4 result

Book1
	A	B
1
2
3
4
5
6
Sheet4

Cell Formulas
Range	Formula
B4:B6	B4	=IF(COUNTIF(Sheet1!$A$4:$A$100,0)>0,"",Sheet1!A4)