# AVERAGEIF Multiple Columns

1. ## AVERAGEIF Multiple Columns

Hi,

I am trying to calculate an average of 5 months in 5 columns (D:H) if criteria in column A is met

I have tried the following but doesn’t seem to be working

=averageif(A:A,”Hire Purchase”,D:H)

Any suggestions would be appreciated.

Thanks in advance.

2. ## Re: AVERAGEIF Multiple Columns

Can you pls uload a sample file?

3. ## Re: AVERAGEIF Multiple Columns

Here is the sample.

4. ## Re: AVERAGEIF Multiple Columns

Oh... I am not that much expert to solve this...
Dont worry.. Others will help you

5. ## Re: AVERAGEIF Multiple Columns

Thanks for trying, anyway.

6. ## Re: AVERAGEIF Multiple Columns

Hi, As already you have average in column "J", you can simply use vlookup for this

Formula:
`Please Login or Register  to view this content.`

7. ## Re: AVERAGEIF Multiple Columns

Hi... got it..

Sample (1).xlsx

8. ## Re: AVERAGEIF Multiple Columns

Originally Posted by Ganesh7299
Hi, As already you have average in column "J", you can simply use vlookup for this

Formula:
`Please Login or Register  to view this content.`

I was trying to avoid creating another column for the average and calculate it in the cell. Thanks for the advice anyway.

9. ## Re: AVERAGEIF Multiple Columns

You're a star. I knew I could count on you here. As always, very helpful.

Many thanks again.

Originally Posted by akhileshgs
Hi... got it..

Attachment 245527

10. ## Re: AVERAGEIF Multiple Columns

Glad I could help you...

Please change the topic to solved if you got what you needed

11. ## Re: AVERAGEIF Multiple Columns

Hi,
In addition to above example, it is average of "D4:H4", means in case of multiple occurrence it will not work.
Below is one more solution for the same
Formula:
`Please Login or Register  to view this content.`

12. ## Re: AVERAGEIF Multiple Columns

I am reviving an old thread because it is very similar to the question I have. Also, I don't think the question was answered all the way. The last poster, Ganesh7299, is correct. The solution provided in the reposted sample file returns the average only for the values in the row where the first occurrence of Hire Purchase happens. In the example, that is D4 through H4.

What Ganesh7299 points out is that there is another row where Hire Purchase appears in Row 8. How do you get those values in cells D8 to H8 to also be part of the average? Ganesh7299 provides a solution, but when I paste it into the sample, I get a #NAME error. I thought there might be a few extra spaces or something in the formula, but that did not fix it. This is the revised version.

=SUMPRODUCT((D4:H11)*(A4:A11=”Hire Purchase”))/(COUNTIF(A4:A11,”Hire Purchase”)*5)

This is exactly what I want to know (use only some rows of data based on a criteria). I'm using Excel 2013 and Windows 7. Thanks.

13. ## Re: AVERAGEIF Multiple Columns

fbrb99 Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

14. ## Re: AVERAGEIF Multiple Columns

Drat! Sorry I missed that. I will post a new one. Thanks.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1