# AVERAGEIF function

1. ## AVERAGEIF function

Hello,
What I need is to average every cell in column A that each share the same value in Column B. This must be done for each unique value in column B. Therefore have the same number of averages in some new Column as there are unique column B values. I believe I can somehow use the AVERAGEIF function.

2. ## Re: AVERAGEIF function

Hi thespacemen and welcome to the forum,

My avatar is from space too..

If you had 2007 or newer Excel we could use the AverageIfs function but you don't have the new one. So here is the formula and an attached example.
``Please Login or Register  to view this content.``

3. ## Re: AVERAGEIF function

So how do I do it with the AVERAGEIFS function because I do have access to more recent excel versions. THANK YOU SO MUCH

5. ## Re: AVERAGEIF function

How can I average a range of numbers if they fall between two numbers? Example: Average column A if the numbers fall between 3 and 9. Thanks for anyone's help!

6. ## Re: AVERAGEIF function

Welcome to the forum,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other 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