Complete the following steps to determine the total deposits received for each tour. a. In cell D2, enter a formula using the SUMIF function that totals the amounts in the Deposits Received column for all Corfu Sailing Voyage tours. Use Corfu Sailing Voyage as the criteria argument, Tour InfolTour] as the range argument, and Tour_Info[Deposits Received] as the sum_range argument in your formula.
b. In cell D3, enter a formula using the SUMIF function that totals the amounts in the Deposits Received column for each Nepal Trekking tour Use Nepal Trekking as the criteria argument, Tour_Info[Tour] as the range argument, and Tour_Info[Deposits Received] as the sum_rang argument in your formula.
c. In cell D4, enter a formula using the SUMIF function that totals the amounts in the Deposits Received column for each Hiking Patagonia tour. Use Hiking Patagonia as the criteria argument, Tour_Info[Tour as the range argument, and Tour_Info[Deposits Received] as the sum_range argument in your formula.