Use the Subtotal command (Data Outline Subtotal) to create subtotals for the total sales in each department. You should then collapse the data so that i looks like this: 2 3 A B C D 1 Date Department Manager Sales + 54 Appliances Total $101,698.91 + 107 Electric Total $136,430.77 + 160 Flooring Total $125,270.10 + 213 Kitchen and Bath Total $141,409.24 + 266 Lawn and Garden Total $131,609.21 + 319 Lumber Total $127,774.93 + + 372 Paint Total $114,739.72 425 426 Plumbing Total Grand Total $129,866.94 $1,008,799.82 127 TI F G H | J K L M N A B C D E 72 1 Date Department Manager Sales 1/1/15 Appliances Sally Jones $2,824.82 3 1/1/15 Electric Bob Macky $164.65 4 1/1/15 Flooring 5 1/1/15 Kitchen and Bath Bill Smoot John Jacobs $446.05 $1,914.31 6 1/1/15 Lawn and Garden Jonathon Ralphson $3,381.88 7 1/1/15 Lumber Benjamin Tesner $97.21 8 1/1/15 Paint Abigail Rae $1,078.34 9 1/1/15 Plumbing Laura Olson $49.28 10 1/8/15 Appliances 11 1/8/15 Electric 12 1/8/15 Flooring Sally Jones Bob Macky Bill Smoot $2,073.22 $1,999.72 $2,180.13 13 1/8/15 Kitchen and Bath John Jacobs $1,711.99 14 1/8/15 Lawn and Garden Jonathon Ralphson $2,139.19 15 1/8/15 Lumber Benjamin Tesner $2,178.21 16 1/8/15 Paint Abigail Rae $2,090.21 17 1/8/15 Plumbing Laura Olson $2,142.44 18 1/15/15 Appliances Sally Jones $191.44 19 1/15/15 Electric Bob Macky $63.31 20 1/15/15 Flooring Bill Smoot $2,970.64 21 1/15/15 Kitchen and Bath John Jacobs $3,312.25 22 1/15/15 Lawn and Garden Jonathon Ralphson $4,434.94 23 1/15/15 Lumber Benjamin Tesner $2,983.15 24 1/15/15 Paint Abigail Rae $361.63 25 1/15/15 Plumbing Laura Olson $3,287.92 26 1/22/15 Appliances Sally Jones $426.48 27 1/22/15 Electric Bob Macky $2,336.84 28 1/22/15 Flooring Bill Smoot $4,519.91 29 1/22/15 Kitchen and Bath John Jacobs $4,171.96 30 1/22/15 Lawn and Garden Jonathon Ralphson $247.40 31 1/22/15 Lumber Benjamin Tesner $3,817.34 32 1/22/15 Paint Abigail Rae $7.75 33 1/22/15 Plumbing Laura Olson $4,590.63 34 1/29/15 Appliances Sally Jones $134.29 35 1/29/15 Electric Bob Macky $2,836.35 36 1/29/15 Flooring Bill Smoot $1,008.23 37 1/29/15 Kitchen and Bath John Jacobs $3,180.07 38 1/29/15 Lawn and Garden Jonathon Ralphson $754.81 39 1/29/15 Lumber Benjamin Tesner $1,325.67 40 1/29/15 Paint Abigail Rae $561.85 0 P Q