[dba-Tech] Excel on averages

You need to create an "array formula" (q.v. in Help.)

"An array formula can perform multiple calculations and then return 
either a single result or multiple results. Array formulas act on two 
or more sets of values known as array arguments. Each array argument 
must have the same number of rows and columns. You create array 
formulas in the same way that you create other formulas, except you 
press CTRL+SHIFT+ENTER to enter the formula."


If your values are in cells C2:C7 enter the following into cell C8:

=AVERAGE(IF(C2:C7<>0,C2:C7,""))

Instead of pressing Enter once you have typed this, press 
Ctrl+Shift+Enter. 

On 26 Aug 2007 at 14:07, Susan Harkins wrote:

> Excel's AVG function uses 0's. Is there an easy way tell Excel to ignore the
> 0's? I only want to average existing values, but I don't want to update the
> range. 
> 
> Susan H. 
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com