Explore BrainMass

Explore BrainMass

    Excel Functions - Sumif, Sumifs and Dropdowns AIS

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. Open the excel file and click on the data worksheet. Use the SUMIF function to calculate the total amount of sales in dollars (A/R Change) for each of the four types (Blue, Red, etc). This should match these totals.
    August Sales in Dollars by Type
    Blue $33,090.89
    Green $36,701.39
    Red $37,061.09
    White $43,480.92
    Total $150,334.29.

    2. Use the SUMIFS function to determine the amount of sales for each type of inventory (Blue, Red, Etc.) for a specific function. Please note that the length of your different ranges must be identical. Ranges have to go to row 6520 or longer.date during August 2010.

    3. Use the Drop Down List feature and the SUMIFS function to determine the amount of dollar sales for each type of inventory (Blue, Red, etc.) for any customer for the month. (Don't use pivot table for customer list use a range reference).

    © BrainMass Inc. brainmass.com June 4, 2020, 2:09 am ad1c9bdddf
    https://brainmass.com/business/finance/excel-functions-sumif-sumifs-dropdowns-ais-442330

    Attachments

    Solution Summary

    The solution creates Sumif, Sumifs and Dropdowns AIS using given data.

    $2.19

    ADVERTISEMENT