Welcome to Westonci.ca, where finding answers to your questions is made simple by our community of experts. Experience the convenience of getting accurate answers to your questions from a dedicated community of professionals. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our platform.

Enter a SUMIF() formula in cell B9 (column heading: Qtr_1) to calculate the total sales for Quarter 1 for the salesperson in cell A9. Your formula should sum up all sales for the salesperson in cell A9 for Quarter 1 (Quarter 1 sales data is found in worksheet "Sales" column D). The salesperson in A9 may have a number of sales in Quarter 1. Your SUMIF formula should total them all up.

Sagot :