Afternoon,
I have been using this formula
=AVERAGEIF(INPUT!C$2:C$9999,"Year 7",INPUT!F$2:F$999)
to work out the average of column F if the value of Year 7 is in column c.
What I would like to do is change this so it only works out the avergae of column f, if Year 7 is in column c, and also M is in column B.
Any suggestions would be greatfully received.
Last edited by Cmorgan; 09-08-2012 at 01:41 PM.
You can use the AVERAGEIFS function. Not having XL2010 here I'm not sure about the syntax
Try
=AVERAGEIFS(INPUT!F$2:F$999,INPUT!C$2:C$9999,"Year 7",INPUT!B$2:B$9999,"M")
http://www.excelfunctions.net/Excel-...-Function.html
Thanks for this.
You're welcome. Thanks for the 'star tap'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks