Help with Averages

[Barbers1]

Hi,
I am struggling to find a way of working with the average formula and a column of 4 numbers.
I have two scenarios (below) that I can’t seem to find a formula for.

1) I want to be able to ignore any cells that have 0 or blank, so that they do not calculate within the average number.
2) If the range of numbers is all ‘0’s, I want it to count as 0 and not give me a #div/0!

Is this at all possible? Is anyone able to help me?
Thank you

 

[Scott T]

Excel 2010
	A	B	C	D
1	0	2	3	4
2
3
4	3
Sheet4

Cell Formulas
Range	Formula
A4	=IFERROR(AVERAGEIF(A1:D1,">"&0,A1:D1),0)

 

[Barbers1]

Thank you SO much for helping me. You’ve literally made my day ?