A
achieve
i am attempting to average a range of cells, in which each cell value cannot
be above a certain quantity. if a cell value is above the set quantity, i
want for excel to calculate the average, excluding the cell reference that
contains the value above the set qunatity. in words, this is what i want to
say (in the numbers/quantitative statement):
if any cells in the range c8:du8 are <4, calculate the average of cells
c8:du8; however, if any cells in this range are >4, calculate the average of
the range, BUT exclude those cells (with values greater than 4) from the
formula.
be above a certain quantity. if a cell value is above the set quantity, i
want for excel to calculate the average, excluding the cell reference that
contains the value above the set qunatity. in words, this is what i want to
say (in the numbers/quantitative statement):
if any cells in the range c8:du8 are <4, calculate the average of cells
c8:du8; however, if any cells in this range are >4, calculate the average of
the range, BUT exclude those cells (with values greater than 4) from the
formula.