You could use a pivot table to accomplish this. Make the date (column A) the
page field. Make the "Closed" (column B) the data value. You don't need row
fields. You can add the "Closed" to the data section 3 times if you want.
Make one a "Sum of Closed" field. Make another a "Count of Closed field".
Make the third a "Average of Closed" field. You do this by setting the pivot
field setting properties. If a date does not yet have a value in the
"Closed" column, it is not counted (and of course sumed), and not included in
the average. You'll just have to refresh the pivot table (exclamation
button) everytime you add data to your table.

Hope this offers an alternative.

Bill Horton

"Diilb" wrote:

Alright here is what I have

- a column that I fill in either a 1 or 0 for each corresponding date.
- I have another Cell for which I am calculating the average of the 1's
based on the total number of cells. eg: =SUM(B5:B39)/ROWS(B5:B22)

The Problem:
I am filling in either a 1 or 0 each day depending on requirements and
the average only works when all the cells are filled in with a one or a
zero.

I am looking a formula that will do something similar to the following:

SUM([ALL_ROWS]) / ROWS([IF_CONTAINING_DATA])

Any ideas would be appreciated

Regards,
Diilb