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

  • Thread starter Thread starter rudyjudy
  • Start date Start date
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.
 
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.
 
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.
 
You must log in or register to reply here.

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

Average range of discontinuous cells 1
#DIV error 2
Red cell for negative numbers in Excel 1
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Spurious Formula Omits Adjacent Cells 2
Spurious Formula Omits Adjacent Cells 1
Average a column that contains one cell of text 3
How to divide numbers in Excel? 0

Back
Top