i have two columns...a and b (a w/ names, and b w/grades). then i have the table lookup with names and grades all mixed up for many rows.
i want to be able to average the grades with appropriate names. can someone help with the formula?
=average(vlookup(name, table, column, false))?? i don't get it to work and how can i specify the grade to average?
any help would be great. thx.
Last edited by noobnxcl; 12-09-2008 at 11:00 PM. Reason: solved
=AVERAGE(IF(A1:A100 = someName, B1:B100))
This is an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.
Last edited by shg; 12-09-2008 at 10:02 PM.
Entia non sunt multiplicanda sine necessitate
i get zero's only and not a number. i tried doing this with a daverage also, but only get zero's. what am i doing wrong?
Dunno. Post a workbook.
You would have to post up a sample for us to see what you're doing wrong. That formula worked fine with columns with this data:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
sorry, i actually saw that it worked. i guess it took a little time to calculate. thx all for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks