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).