| Home |
| Search |
| Today's Posts |
|
#20
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average of top 3 numbers.
Check your email.
Good luck. *********** Regards, Ron "Belzbub" wrote: What the *#¤*¤!#"@£$ is wrong with this thing..... No matter what i do, copy the formula and pasting it in the sheet it woun`t work. Can it be something with the properties in excel? Can you DL the sheet, change it and mail it back to me? I would be very happy if you were so kind. Belzbub Ron Coderre skrev: First, I had no problem putting the formula into your worksheet. Second, In your spreadsheet, you have less than 3 numbers in the range E6:W6 causing the formula to return #NUM!. When I entered a third number, the formula calculated properly. I changed the formula to this to trap the "less than 3 numbers" situation: =IF(COUNT(E6:W6)<3,"Less than 3 numbers",AVERAGE(LARGE(E6:W6,{1,2,3}))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
| Average If Question | Excel Discussion (Misc queries) | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| How do I drop the lowest 2 numbers and then average? | Excel Worksheet Functions | |||
Threaded Mode
