|
|
#5
11-08-2016, 06:44 AM
|
|||
|
|||
Almost there!
Hi. That totally worked!
Last question: when values to be averaged are not entered and cells are consequently left blank, there are divide by zero error messages showing. Only when I enter at least one value does the result display and these error messages disappear. In the following formulas, is there a way to show a blank cell, not a divide by zero error, when no values to be averaged are entered? =ROUND(AVERAGE(Q5:Q7),1) =Vlookup(Q8, $B$38:$C$78,2,) Screen Shot 2016-11-08 at 7.38.24 AM.png 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C
|
rick10r | Excel | 1 | 07-05-2016 12:07 PM |
|
Search Range Within Cell or Cells
|
COEngineer | Excel | 1 | 06-01-2016 11:50 AM |
| Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
|
Moving formula range multiple cells when moving sum over one cell
|
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
Mac OS X 
Office 2008 for Mac
Threaded Mode