Case EX 13-2 Gregory works for the local public television station. The station has recently held a TV pledge drive and they have received a large number of pledges from viewers and businesses. The data about the pledge drive is stored in a worksheet. The worksheet has six columns: First Name, Last Name, Address, Phone, Pledge, Received. The Received column contains "Yes" or "No" values depending on whether the amount pledged has been received by the station. If Gregory wants to find out the total amount of money that has actually been received by the station, he needs to use the ____ function.
A) COUNT
B) SUMIF
C) COUNTA
D) VLOOKUP

Question

Quizplus · Accepted Answer

The best choice to use in this scenario is the SUMIF function, which allows you to sum only the values in a range that meet a certain criterion. In this case, Gregory would want to sum all of the pledge amounts from the pledges that have been marked "Yes" in the Received column. The SUMIF function can be used for this purpose by specifying the range of pledge amounts and the criterion of "Yes" in the Received column.

Case EX 13-2 Gregory Works for the Local Public Television