L
Larees
I have been using the averageif formula in 2007.
According to the help file the "range" or "average_range" can include
arrays, However when I have attempted to set an array for evaluation only the
first column is evaluated in the result. I only discovered this when I
compared it to my old method which was to use an array function "average(if".
Is this a problem with the averageif formula or am I missing something?
Larry
Syntax
AVERAGEIF(range,criteria,average_range)
Range is one or more cells to average, including numbers or names, arrays,
or references that contain numbers.
Criteria is the criteria in the form of a number, expression, cell
reference, or text that defines which cells are averaged. For example,
criteria can be expressed as 32, "32", ">32", "apples", or B4.
Average_range is the actual set of cells to average. If omitted, range is
used.
According to the help file the "range" or "average_range" can include
arrays, However when I have attempted to set an array for evaluation only the
first column is evaluated in the result. I only discovered this when I
compared it to my old method which was to use an array function "average(if".
Is this a problem with the averageif formula or am I missing something?
Larry
Syntax
AVERAGEIF(range,criteria,average_range)
Range is one or more cells to average, including numbers or names, arrays,
or references that contain numbers.
Criteria is the criteria in the form of a number, expression, cell
reference, or text that defines which cells are averaged. For example,
criteria can be expressed as 32, "32", ">32", "apples", or B4.
Average_range is the actual set of cells to average. If omitted, range is
used.