=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,