You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for creating
various types of reports. You have created a report in the format given below:
In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell.
Which of the following formulas will provide the required result?
A.
COUNTIF(B2:C5,”=Yes”)
B.
COUNTIF(B2:B5,”=Yes”,C2:C5,”=Yes”)
C.
COUNTIFS(B2:C5,”=Yes”)
D.
COUNTIFS(B2:B5,”=Yes”,C2:C5,”=Yes”)
Explanation:
In order to get the required result, you will have to insert the following formula in the B7 cell:
COUNTIFS(B2:B5,”=Yes”,C2:C5,”=Yes”)
Only Sarah and David have exceeded their January and February quotas, therefore the formula will
provide 2 as the result.