| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average only cells that contain numbers | Excel Worksheet Functions | |||
| average a continuous group of numbers and negative numbers are 0 | Excel Worksheet Functions | |||
| To get an average of a column of numbers not zero/blank cells | Excel Worksheet Functions | |||
| how do I get excel to add,then average numbers with two decimals? | Excel Worksheet Functions | |||
| Excel-only average cells if two cells in same row, meet two condit | Excel Worksheet Functions | |||
Hybrid Mode
