Discussion on:

Message 10 of 11
0 Votes
+ -
Don't miss the point
This is an entirely new functionality. Don't get confused by the example cited, which uses the same range for range criteria 1 and range criteria 2.
This formula works as a "countif a is true in range 1, AND b is true in range 2, AND c is true in range 3... (in up to 127 ranges of the same size)".
Posted by Mark.Mathews
3rd Apr 2012