get an average of 3 cells, if they all have numbers, in excel.
 

In excel I need to average 3 cells, only if they all contain a number.
and if they don't contain a number, don't display an error.

get an average of 3 cells, if they all have numbers, in excel.
 

"rudyjudy" wrote:
In excel I need to average 3 cells, only if they all contain a number.
and if they don't contain a number, don't display an error.

=IF(COUNT(A1,B2,C3)=3, AVERAGE(A1,B2,C3), "")

Unfortunately, you will not see this response unless you use a different NG
interface, e.g. Google Groups or a newsreader that access the MSnews server,
msnews.microsoft.com. There is a problem with the MSDG web interface, which
has not been fixed for over 22 hours now.

get an average of 3 cells, if they all have numbers, in excel.
 

On Sun, 10 Jan 2010 01:25:01 -0800, rudyjudy
wrote:

In excel I need to average 3 cells, only if they all contain a number.
and if they don't contain a number, don't display an error.

Highlight the three cells and look down at the bottom of the worksheet
window at the status bar. The average is displayed.