At Westonci.ca, we make it easy to get the answers you need from a community of informed and experienced contributors. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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.