Hello, I need help with figuring out which congregate function I should use on Excel. Thanks!

1.7 Complete the alculations in Table 4. a. Notice that the salespeople have automatically populated based on the salespeople pasted into table 2. b. Use appropriate conditional aggregate functions in columns J and K. c. When possible, reuse the formulas you create in row 41 of table 4 to complete the calculations for the rest rows in the table. Table 4 1.7 Complete the alculations in Table 4. a. Notice that the salespeople have automatically populated based on the salespeople pasted into table 2. b. Use appropriate conditional aggregate functions in columns J and K. c. When possible, reuse the formulas you create in row 41 of table 4 to complete the calculations for the rest rows in the table. Table 4