Case 19-1 Macy Is the Treasurer for a Professional Organization

Multiple Choice

Case 19-1 Macy is the treasurer for a professional organization, and she is compiling the financial data to present to the board members at the next meeting. Macy wants to show the organization's total dollar amount of dues collected in the cells B2 to B40. Which is the correct formula?

A) =COUNT(B2:B40)
B) =SUM(B2,B40)
C) =SUM(B2:B40)
D) =TOTAL(B2:B40)