What value would be returned based on the formula in Cell D49?
The correct answer is the second option = 1
The purpose of a COUNTIFS function is to count the cells that would match certain criteria. The value returned would be the number of times criteria are met.
The function is
=COUNTIFS (range1, criteria1, range2, criteria2, . . . )
It will evaluate the first range and its criteria, then the second range and its criteria and so on. Thus, in this case, the value returned would be 1 as both the criteria are met only a single time.