## 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.