What formula will:
Average all the returns in column “B” that are adjacent to say, every value “7” in column “A”?
Column “A” starts on line 3, and is open-ended; its entries are not in numerical sequence.
I'm using Excel 2010
mgs
Last edited by mgs; 12-13-2011 at 12:07 AM.
use averageifs function
If your problem is not solved, upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Hi mgs,
Basis your explanation, you can use the following formula to get the required average:-
{=AVERAGE(IF($A3:$A$1048576=7,$B$1:$B$1048576,""))}
Above is a array formula and hence needs to be entered using key combination Ctlr + Shift + Enter.
Regards,
DILIPandey
< click on below 'star' if this helps >
DILIPandey
+919810929744
dilipandey@gmail.com
Thanks Azam, It works well.Originally Posted by Azam Ali
Cheers,
mgs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks