Average IF

[howardjo]

Morning,

Is there a function which would allow me to "Average IF" in the same way you would use SUMIF.

I am using this formula for SUMIF, and I want it to be exactly the same, except it averages the data rather than sums.

=SUMIF($Q$17:$Q$65536,"February",$AB$17:$AB$65536)

Regards

Howardjo

[daddylonglegs]

You can use

=AVERAGE(IF($Q$17:$Q$65536="February",$AB$17:$AB$65536))

which is an array formula and, as such, needs to be confirmed with CTRL+SHIFT+ENTER, or you can divide the SUMIF by a COUNTIF like this

=SUMIF($Q$17:$Q$65536,"February",$AB$17:$AB$65536)/COUNTIF($Q$17:$Q$65536,"February")

[howardjo]

Thanks for your reply. This has solved the issue.

Regards

Howardjo