JoshuaX1980
Board Regular
- Joined
- Jan 26, 2005
- Messages
- 80
Hi,
I want to get the average of three cells, one of these cells has no value and is assigned #VALUE (because I calculated with it in other worksheets), now I want the average value of these three cells to be the average value of the two remaining cells. So:
4
#value
6
I want the outcome of Average(A1:A3) to be 5. Now I get #value as an outcome.
I do not want the outcome to become (4+6+0)/3=3.3 ( no zero value for the #value)
I hope somebody can help me.
Cheers,
Lennart
I want to get the average of three cells, one of these cells has no value and is assigned #VALUE (because I calculated with it in other worksheets), now I want the average value of these three cells to be the average value of the two remaining cells. So:
4
#value
6
I want the outcome of Average(A1:A3) to be 5. Now I get #value as an outcome.
I do not want the outcome to become (4+6+0)/3=3.3 ( no zero value for the #value)
I hope somebody can help me.
Cheers,
Lennart