AVERAGEIF function

**thespaceman** · 07-03-2011, 08:22 PM

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.

**MarvinP** · 07-03-2011, 08:47 PM

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.

**thespaceman** · 07-03-2011, 10:30 PM

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

**MarvinP** · 07-03-2011, 10:55 PM

See attached.
and read http://www.excelfunctions.net/Excel-...-Function.html

**Ecel12** · 08-24-2011, 01:50 PM

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!

**NBVC** · 08-24-2011, 01:59 PM

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.