Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
2.1.879 Part 1 Section 18.17.7.21, AVERAGEIFS
Collapse the table of content
Expand the table of content

2.1.879 Part 1 Section 18.17.7.21, AVERAGEIFS

a. The standard indicates the Average-range need not have the same size and shape as cell-range-1 through cell-range-n.

Office requires each cell-range-1 through cell-range-n to have the same size and shape as the average-range.

b. The standard states that argument cell-range-n is of type number, expression, reference, or text; while argument selection-criteria-n is of type reference or text.

In Office, argument cell-range-n can be of type reference and argument selection-criteria-n can be of type number, expression, reference, or text.

Show:
© 2015 Microsoft