Microsoft Office Tutorials and References
In Depth Information
Figure 15-4 shows an example.
The two ranges must be the same size and of the same dimensions.
This formula works by creating a new array of the same size as the ranges being compared. The IF function fills
this new array with 0s and 1s (0 if a difference is found, and 1 if the corresponding cells are the same). The
SUM function then returns the sum of the values in the array.
The following array formula, which is simpler, is another way of calculating the same result: