LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average only cells that contain numbers April Excel Worksheet Functions 3 April 24th 23 09:07 AM
average a continuous group of numbers and negative numbers are 0 Dumbfounded Excel Worksheet Functions 3 October 15th 08 11:53 PM
To get an average of a column of numbers not zero/blank cells Neil Excel Worksheet Functions 4 June 22nd 08 02:57 PM
how do I get excel to add,then average numbers with two decimals? wenz324 Excel Worksheet Functions 6 February 2nd 08 07:38 PM
Excel-only average cells if two cells in same row, meet two condit Eulie-Denver Excel Worksheet Functions 5 October 5th 06 11:15 PM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"