Hello,

You have to add  ”<>0” as a criteria.

Hi Anders,

I did try that using formula; =AVERAGEIF($E$4:$E$158,$C160,F$4:F$158,"<>0") but I get an error message that says 'You've entered too many arguments for this function'?

Thanks

Paul

Hello Paul,

When you have two or more criterias you have to use AVERAGEIFS function.

The syntax is =AVERAGEIFS(average_range, criteria_range1, criteria1, criteria_range2, criteria2,…)

So assuming the criteria range is the same your formula should then be =AVERAGEIFS(F$4:F$158, $E$4:$E$158, $C$160, $E$4:$E$158, ”<>0”)

I'd have guessed the 0s were in column F, so:

=AVERAGEIFS(F$4:F$158,$E$4:$E$158,$C160,F$4:F$158,"<>0")

Many thanks to Anders & Velouria

Simple when you know how?

Regards

Paul