Averageif specific cells rather than a range

[IainCD]

I am trying to create an averageif formula but rather than for a range, a specific set of cells:

A1, A5, A7

I thought it would be as follows:

=averageif((A1, A5, A7), "<>"))

But this returns #Value!

Any advice or help would be much appriciated.

Iain.

 

[Fluff]

Why not just use Average
=average(A1, A5, A7)

 

[IainCD]

Why not just use Average
=average(A1, A5, A7)

Thanks for the reply.

My cells on occasions will all be blank and if I used the formula above this returns #DIV/0!

Any ideas on how to get around this?

Iain.

 

[Fluff]

How about
=IFERROR(AVERAGE(A1, A5,A7),"no values")

 

[IainCD]

How about
=IFERROR(AVERAGE(A1, A5,A7),"no values")

Thanks. That worked a treat. Much appriciated. Iain.

 

[Fluff]

You're welcome & thanks for the feedback