It's because the average in the statusbar includes zero in it's calculation
so if you have zeros you should
get a smaller number using the statusbar and selecting the whole range as
opposed to the formula

--


Regards,


Peo Sjoblom

"Pammy" wrote in message
...
Peo Sjoblom:

I changed the formula to what you wrote and did Ctrl + Shift +Enter and I
get 24, but if I select ac06:ac11342 and look at the status bar it is
10.4.
Any idea? I even copied and pasted your formula.

"Peo Sjoblom" wrote:

You are using an incorrect formula


=AVERAGE(IF(AC6:AC11342<0,AC6:AC11342))

entered with ctrl + shift & enter

--


Regards,


Peo Sjoblom

"Pammy" wrote in message
...
=AVERAGE(AC6:AC11342<0,AC6:AC11342)
This is my formula for an average, the rows are filled in from ac6 -
ac831
and it gives a number beginning with ac6 from a calculation. If there
is
no
entry then it populates a zero. I get an average of 13 that is showing
on
the status bar if I select the cells ac6:ac831, but in my cell where
the
average formula is (notice it goes to ac11342 I get an average of 10.
All
the cells in this column have zeros where there have been no entries
yet,
but
will change as data is entered on the row. I have it set to 11342 so
the
person can enter without having to do anything.
I do shift+control and enter in the formula bar. Any idea? It is
formatted
to a number. Thanks,