Which of the following formulas will provide the required result?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *