Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Averages

Could someone please advise me a nice simple formula for giving an average
for non zero entries. The average function in Excel provides an average of a
list of numbers including numbers that are zero. I need the average of just a
series of numbers where zeros are not considered in the result.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
averages without zero RcWend Excel Worksheet Functions 6 July 10th 07 09:20 PM
Averages Kimbe Excel Discussion (Misc queries) 1 May 31st 07 04:37 PM
Averages Zygy New Users to Excel 16 June 19th 06 10:01 PM
averages Metolius Dad Excel Worksheet Functions 1 February 7th 06 01:44 AM
averages ashw1984 Excel Discussion (Misc queries) 1 January 23rd 06 09:24 AM


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"