Thread: Average first n numbers in a range (there may be less than n numbe
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike A. M.
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote