Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Way to average a group of results from using LOOKUP?
I have a table of scores achieved as a result of using the LOOKUP function
(typical % converted to score type of scenario). I am trying to average (say 10) resulting scores but am running into problems where I constantly receive the #div/0 error or receive a 0. I can't see where I'm dividing by 0. Any thoughts on how to work around this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for variable-height group average | Excel Worksheet Functions | |||
Average a group, where grouping is Conditional on other col.??? | Excel Discussion (Misc queries) | |||
sum the results of a group of formulas | Excel Worksheet Functions | |||
How do I extract 3 middle results and average them in excel | Excel Worksheet Functions | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) |