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

House Number	Weight
1	55
2	80
1	0
3	55

<tbody>
</tbody>

 

[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