I think I'm reading you right, you want to take an average of values only if
they have a 1 in the 1's and 0's column?

In this case...assume the column containing 1's and 0's is A and the values
you want to average are in column B.

=AVERAGE(IF(A1:A1000=1,B1:B1000,"")

Change the 1000 to wherever your data ends.

Does that help?

--
Regards,

Dave


"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