I am using the 2003 version. When i typed that formula in, it came back with
the "#VALUE!" error.

"T. Valko" wrote:

What version of Excel are you using?

This array formual** will work in all versions:

=AVERAGE(IF(AP13:BA130,AP13:BA13))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Shannakinz" wrote in message
...
I have columns set up for each month where we enter the total number of
hours. After these columns, i have a column for "total for the year
(hours)"
and for "average of the year (hours)". Right now, i've just put in a basic
average function to calculate using the columns for the months. Example:
=AVERAGE(AP13:BA13).

My problem is that some months do not have values, and i would like to
exclude them from the average calculations. Is there a way to tell excel
that
it should only calculate the average of the months that have a value 0 ?

Thanks.