Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

2.1.1035 Part 1 Section 18.17.7.308, SUMIFS

a. The standard states that sum-range need not have the same size and shape as cell-range-1 through cell-range-n.

In Office, each cell-range-1...cell-range-n shall have the same size and shape as sum-range.

b. The standard states that cells in sum-range that contain TRUE evaluate to 1; cells in sum-range that contain FALSE evaluate to 0.

In Office, cells in sum-range that do not contain numeric values evaluate to 0.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.