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

Multiple Choice

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