"B G" skrev i en meddelelse
...
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

Hi Barb

The AVERAGE() function automatically excludes blank cells.


--
Best regards
Leo Heuser

Followup to newsgroup only please.