Trouble with averageifs forumla

[Mushroomman]

Hi,

I'm trying to find the average of something based on 2 criteria.

I need to find the average weight depending on 1)house number and 2)that the value that is in the cel is not 0.

For example

I have a sheet like this below. I need to average the weights in house 1. I know I can use averageif to get the weights of house 1, but I also need it to ignore the weight if it is 0 (at a later point the 0 will be changed and I will want to include it then).

Cheers
[TABLE="width: 500"]
<tbody>[TR]
[TD]House Number[/TD]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]55[/TD]
[/TR]
</tbody>[/TABLE]

 

[hippiehacker]

this would do

=AVERAGEIFS(B:B;A:A;1;B:B;">0")

 

[Mushroomman]

I don't know why but I was using '>0' rather than ">0". So simple.

Thanks