The following SUMIFS function was entered into a cell on the Summary worksheet in an Excel workbook: =SUMIFS(Detail!C5:C15,Detail!A5:A15,Summary!A6,Detail!D5:D15,">"&Summary!E2)

Which of the follow is true with regards to this function?

• The function will produce an output by summing values in the range D5:D15 on the Detail worksheet based on the defined criteria.

• The output of the function will be an error because the criteria2 argument, ">"&Summary!E2, does not contain a valid logical test.

• The function will produce an output by summing values in the range A5:A15 on the Detail worksheet based on the defined criteria.

• The function will search for values that are greater than the entry in cell E2 on the Summary worksheet in the range D5:D15 on the Detail worksheet.

• The function will search for the entry in cell A6 on the Summary worksheet in the range D5:D15 on the Detail worksheet.