Rocio3871go Rocio3871go Business Answered In cell b5, enter a formula using the sum function and 3d references to total the sales for batteries and chargers using the data on the quarter 1, quarter 2, quarter 3, and quarter 4 worksheets.