Step-by-step instructions on how to go about this, please!
Other sheets.
3. Use DSUM to summarize mailing data. a. On the Mailings sheet, note that number sent is located in the third column and response data is in the fourth column b. Click the Criteria sheet tab. Select cell B2 and type lan* to select data for the landscape Design department C. Click the Mailing Stats sheet tab and select cell B7 d. Use DSUM with the range name Responses as the Database argument. Type 3 for the Field argument, and use on absolute reference to cells B1:B2 on the Criteria sheet as the Criteria argument. e. Copy the formula to cell C7 and edit the Field argument to use the fourth column t. Complete criteria for the two remaining departments on the Criteria sheet. 9. Cick the Mailing Stats sheet tab and select cell B8. h. Use DSUM in cells 88:C9 to calculate results for the two departments. 4. Use SUM in cells B10:C10. 5. Format all values as Comma Style with no decimal places. B D Classic Gardens and Landscapes 1 Mailings by City and Department 2 3 City # Mailed # Responses 4 Ashland City 1690 210 Department Lawn & Maintenance Patio & Furniture Lawn & Maintenance 2170 435 5 Belle Meade 6 Brentwood 938 125 7 Burns Patio & Furniture 1475 413 8 Carthage 1225 343 9 Centerville 1260 353 2235 618 10 Charlotte 11 Coopertown 12 Cross Plains Lawn & Maintenance Landscape Design Landscape Design Lawn & Maintenance Patio & Furniture Patio & Furniture 2380 300 2545 550 13 Dickson 1470 322 14 Fairview 2655 743 15 Forest Hills 2915 375 Patio & Furniture Landscape Design Patio & Furniture Landscape Design 16 Franklin 740 125 17 Gallatin 985 325 18 Goodlettsville Lawn & Maintenance 1555 435 19 Gordonsville Lawn & Maintenance 5885 307 1 20 Hendersonville Patio & Furniture 1315 368 21 La Vergne Landscape Design 1120 314 22 Lebanon Patio & Furniture 960 175 23 Mount Juliet Lawn & Maintenance 1885 527 5100 300 1430 389 1420 300 24 Murfreesboro Lawn & Maintenance 25 Portland Landscape Design 26 Smyrna Lawn & Maintenance 27 Spring Hill Patio & Furniture 28 Springfield Landscape Design 29 30 Mailings Mailings Stats 1460 460 1610 450 Criteria Employee Insurance Birt Copy - Format Painter B TU- ..A Merge & Cente Clipboard Font Alignment C10 > f A B D 1 Classic Gardens and Landscapes 2 3 Third Quarter Mailings 5 Total Sent Total Responses Response Rate 6. Department/Group 7 Landscape Design 8 Lawn & Maintenance 9 Patio & Furniture Total 20 101 12 13 14 15 16 17 18 Response Rate Determination 20% and above Excellent 15% and above Very Good 10% and above Good Below 10% Average City Smyrna # of Responses 300 19 20 21 22 23 24 25 26 Mailings Mailings Stats Criteria Employee Insurance Birth Dates 3 Type here to search o Calibri -11 Xcut Copy - Format Painter Clipboard SA. Wrap Text Merge & Center - BLU- Font Alignment F12 fe A B D E Response Department # Mailed # Responses Rate 1 City 2 3 Response Department # Mailed # Responses Rate 4 City S 6 Response Rate 7 City Department # Mailed # Responses 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Mailings Mailings Stats Criteria Employee Insurance Birth Dates Ready Type here to search o Bi
