Excel: Average in Excel

Hi All, I have four colums. I wan to get the average from it. For Example A B C D 12 - 25 - - 45 - - - - 17 34 when I am writing formula in E1 I am getting error for "-" sign. What I want is that where there is "-" sign it should avoid that cell and give me the average of the remaining cell. I am trying with if and and formula but no result found. Can you please guide me? Thanks in advance!!

This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of August 29, 2014.

For more resources for Microsoft Excel