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

R

rudyjudy

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.
 
J

Joe User

rudyjudy said:
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.
Click to expand...

=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.
 
C

CellShocked

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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
#DIV error 2
Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Trying to find additional ranges outside of min, max, and average 2
Can I add a range and then divide that sum by a specific value? 2
countifs Function not giving desired result with date criteria 2
Spurious Formula Omits Adjacent Cells 2

Top