Financial Spreadsheet Skills Assessment

In columns A and B is a table of amounts that various subsidiaries have transacted. You want to find the total amount transacted but only for a subset of the subsidiaries: The ones shown in the "include in total" table in column D.

Which formula would you put into cell B11?

• A: {=SUMIF(A3:A9,D2:D3,B3:B9)}
• B: {=SUM(SUMIF(A3:A9,D2:D3,B3:B9))}
• C: {=SUMIF(SUM(A3:A9,D2:D3,B3:B9))}
• D: {=SUM(SUM(IF(A3:A9,D2:D3,B3:B9)))}

   A     B     C     D