would like to find the average number of units sold per transaction by sales person Alan. Which of the following formulas would accomplish this task? This is a multiselect question. Please select all correct answers. Array Entered =SUM(\$D\$4:\$D\$95="Alan",\$C\$4:\$C\$95) =SUMPRODUCT(-(\$D\$4:\$D\$95="Alan"),\$C\$4:\$C\$95)/SUMPRODUCT( (($D$4:$D$95="Alan")) =AVERAGEIFS(\$C\$4:\$C\$95,\$D\$4:\$D\$95,"Alan") =SUMPRODUCT(--(\$D\$4:\$D\$95 ="Alan"),\$C\$4:\$C\$95)