I should further explain that your array formula will have { and }
surrounding it when you look at it in the formula bar. These identify an
array formula. Do not type these in. Pressing CTRL+SHIFT+ENTER places the {}
around the formula. So if in A1:A5 you had the values 2, 0, 4, blank, 6 the
in-memory array would look like: 2, false, 4, false, 6. The array function
would ignore the false values and average the 3 numbers 2, 4 and 6 for an
average of 4. If you averaged these in the spread sheet column, the average
function would average 2, 0, 4 , 6 for an average of 3.


"Treesy" wrote in message
...
Is there a way to not have a blank or zero value not be counted in an
average
function. Example:

I have a spreadsheet that has a year's worth of data. Currently, it is
only
filled in through June. At the very end, I want it to average some of the
data. The formula has 12 cells that I want averaged but if one of those
cells is blank or zero, I want it ignored. 6 of the 12 cells have data.
Right now, I want it to average the 6 cells that have data. Next month,
it
will average 7, so on and so forth. Right now, it is taking the 6 values
and
dividing by the 12 cells, even though 6 of them contain nothing. I guess
I
want the calculation to change as data is entered without having to change
the formula every month and add the new cell. Is this possible??