Average help please

[C90RanMan]

I am attempting to Average across four unbound cells. Some may have values or may not but i only need to average the values that are greater than zero. Dif1, Dif2, Dif3 and Dif4 are the names of the unbound cells. I am using the following formula:



=(Nz([Dif1],0)+Nz([Dif2],0)+Nz([Dif3],0)+Nz([Dif4],0))/(IIf(IsNull([Dif1]),0,1)
+IIf(IsNull([Dif2]),0,1)+IIf(IsNull([Dif3]),0,1)+IIf(IsNull([Dif4]),0,1))



Where: Dif1 = 1
Dif2 = 1
Dif3 = 1
Dif4 = 0

The answer being generated is 6 when it should be 1.

Thanks Again

[pkstormy]

I might break this apart to troubleshoot it. You could have another set of unbound fields which utilize the NZ in the expression (ie. one based on [Dif1], another based on [Dif2], etc...of your original 4 fields) to make sure it's putting in a 0 or the value in those fields and then add/average those fields.