G
Guest
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.
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.