Thread: get an average of 3 cells, if they all have numbers, in excel.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CellShocked CellShocked is offline
external usenet poster
  
Posts: 277
Default 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 With QuoteReply With Quote