In which case, specify ranges which don't include that column.
--
David Biddulph

"Paige06" wrote in message
...
and I forgot to mention I need to skip one column

"Bob Phillips" wrote:

=AVERAGE(B38:M38)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Paige06" wrote in message
...
I need to average a row some cells have 0's but I need to include them
in
the function so it averages correctly. The formula I currently have is
this
=AVERAGE(IF(B38:M38<0,B38:M38,"")). It is working with the cells with
numbers, but not the cells that do not. Example : jan - 5, feb - 7,
mar.
0,
april - 18 = 30 divided by 4 = 7.50. My sheet will only calulate 3. Any
suggestions?????