#### niladri2005

##### Board Regular

- Joined
- Sep 21, 2012

- Messages
- 109

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!!

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!!

Last edited: