Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking-up Columns w/calc'd Values ONLY to Calculate Average
Your help will be appreciated. PROBLEM: The formula below returns an answer
of 100% (WHICH ISN'T RIGHT). The correct result should be 11%. =IF(COUNTIF(F18:M18,"<0"),LOOKUP(2,1/(F18:M18<0)*ISNUMBER(F18:M18)),AVERAGE(F18:M18)-AVERAGE(F22:M22)) WHAT I AM TRYING TO ACCOMPLISH (LAYOUT BELOW): 1) LOOKUP CALCULATED VALUES IN F18:M18 I.E. F18:I18 2) LOOKUP CALCULATED VALUES IN F22:M22 I.E. F22:I22 3) SUBTRACT INCREMENTING AVERAGE OF F22:M22 FROM INCREMENTING AVERAGE OF F18:M18 ************WORKSHEET LAYOUT**************** COLUMN D E F G H I J K L M ROW 18 50% 33% -25% 50% 0% 0% 0% 0% 19 4 6 8 6 9 20 21 5 4 2 6 2 22 -20%-50% 200% -67% 0% 0% 0% 0% Thank-you - Sony -- Sony Luvy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting values from columns into one cell | Excel Discussion (Misc queries) | |||
How to calculate average from large dataset in several sheets? | Excel Worksheet Functions | |||
How do I match identical values in 2 columns and then sort? | Excel Discussion (Misc queries) | |||
calculate average in percentage coloumn with #DIV/! (ignore error | Excel Discussion (Misc queries) | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |