The AVERAGE formula excludes blank cells, or cells not containing a value.

=AVERAGE(A1:A200) would sum the cells in that range, count the number of
cells having a value and use the count as the divisor.
--
Kevin Backmann


"B G" wrote:

I have a spreadsheet that I am trying to determine the average price. The
columns are each a different product and each column does not have a value on
each row. I would like to find the average price of each column, but need to
exclude the rows that are blank. I had thought I could do this with a
countif and avg formula, but got an error that I have too few arguments.

column E has 125 values in it and there are 575 rows, so 350 are blank. I
don't want to have those 350 included into the formula that gives me the
average.

I know this is simple, but not sure what needs to go in to exlude any cells
are that blank.

--
Barb