LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default No including ZERO'S when using Average fucntion

I am using the average function in a large documents for different time
periods. Some time periods have ZERO, which bias the average.

Can I use the average function but not have it count zeros in the total?
 
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
Average formula Counting zero's How do I get just the numers counted. [email protected] Excel Discussion (Misc queries) 1 March 2nd 07 02:56 PM
Average formula Counting zero's How do I get just the numers counted. [email protected] Excel Discussion (Misc queries) 2 March 2nd 07 03:11 AM
Excluding Zero's from Average (SumIF / CountIF) Alex Excel Worksheet Functions 5 March 28th 06 07:27 PM
Average Non-Continuous Cells Without Zero's raeleanne Excel Worksheet Functions 8 July 22nd 05 02:48 PM
Average non continguous cells, excluding zero's Keithlearn Excel Worksheet Functions 2 April 27th 05 01:22 PM


All times are GMT +1. The time now is 05:51 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"