| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
average with formula in cells
Hi
1.In all my summary sheets I have the formulas like =IF(INDIRECT("'"&(C1)&"'!c91")="",NA(),INDIRECT("' "&(C1)&"'!c91")) This works fine and returns #n/a when no value in cells and graph does not run to zero 2.I have summed all the summary info using data/consolidate method and adjusted the autogenerated formula to =SUM(IF(ISNUMBER(B78:B94),B78:B94)), this takes care of not counting the #n/a. Now I wish to average all the summed data, but some of the cells are showing zero, owing to the formula above in point 2. but do not wish to count them, unless they are a true zero Q. how can I sum the range (b78:B94) to return #n/a if non of the cells contain a number, including zero. Help Appriciated Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200810/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for average of cells that have blanks | Excel Worksheet Functions | |||
| combining weekday formula, average and going back 7 cells | Excel Discussion (Misc queries) | |||
| Formula to average the last 4 non-blank numerical cells of a row? | Excel Worksheet Functions | |||
| average formula ingoring empty cells | Excel Worksheet Functions | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
Threaded Mode
