Question

Enter a sumif function in cell c3 on the summary worksheet. The function should compute the sum of the entries in the current percent of portfolio column on the investment detail worksheet where there is a match in the investment type column on the investment detail worksheet with cell a3 on the summary worksheet. Include cell capacity through row 25 when defining arguments that require a cell range and use absolute references when needed.

Answer 1

To compute the sum of portfolio percentages by investment type, use the SUMIF function in cell C3 of the Summary worksheet, referencing the appropriate cells from the Investment Detail worksheet, ensuring that the formula looks like: =SUMIF(InvestmentDetail!B2:B25, A3, InvestmentDetail!C2:C25).

Step-by-step explanation:

To enter a SUMIF function in cell C3 on the Summary worksheet, you need to reference the Investment Detail worksheet and look for matches with cell A3 on the Summary worksheet. The function should sum the entries in the 'Current Percent of Portfolio' column where it corresponds to the 'Investment Type' specified in A3.

Considering the instructions, the formula in cell C3 will look like this:

=SUMIF(InvestmentDetail!B2:B25, A3, InvestmentDetail!C2:C25)

It's important to make sure you have the correct worksheet names and cell references. The range B2:B25 represents the 'Investment Type' column on the Investment Detail worksheet, A3 is the specified 'Investment Type' on the Summary worksheet, and C2:C25 is the 'Current Percent of Portfolio' that we want to sum.