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.



Answer :

Other Questions