| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average first n numbers in a range (there may be less than n numbe
I want average the first six numbers in a series of rows.
The series may include blanks, zeros, alpha charachters. There may not be six numbers in the series If there are less than six I still want the average , if there are more than six, I just want to average the first six. I have tried UDF methods and VB code, but can't get the right result. Any sane suggestions? Thnaks -- Mike A. M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF than statement in a range of numbers? please help? | Excel Discussion (Misc queries) | |||
| Average of numbers within a range meeting certain criteria | Excel Worksheet Functions | |||
| Can I sum or average a range with more than 1 condition? | Excel Discussion (Misc queries) | |||
| average positive numbers | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
