# Thread: Averageif specific cells rather than a range Thanks: 0 Likes: 0

1. ## Averageif specific cells rather than a range

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.

2. ## Re: Averageif specific cells rather than a range

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

3. ## Re: Averageif specific cells rather than a range

Originally Posted by Fluff
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.

4. ## Re: Averageif specific cells rather than a range

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

5. ## Re: Averageif specific cells rather than a range

Originally Posted by Fluff
=IFERROR(AVERAGE(A1, A5,A7),"no values")
Thanks. That worked a treat. Much appriciated. Iain.

6. ## Re: Averageif specific cells rather than a range

You're welcome & thanks for the feedback

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•