If (cell) is (range of cells), then (cell) should be (range of cells)

xor · #1 11-07-2016, 11:12 PM

Take a look at the attached.

ExcelPatient · #2 11-08-2016, 06:44 AM

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