In an Excel workbook: $=$COUNTIFS$($Detail$!$F$8$:F$20,$Summary!B$6,$Detail!H$8$:H$20,"<7")$

Which statement is correct?

Question $42$ options:

The function will count the number of cells in the range F$8$:F$20$ and H$8$:H$20$ where the value is less than $7$ and matches the value in cell B$6$ on the summary worksheet.

Cells will be counted in the range F$8$:F$20$ where cells in the range H$8$:H$20$ match the value in cell B$6$ on the Summary worksheet and where values are less than $7.$

This function will likely be copied and pasted to other cell locations in the Summary worksheet.

The function will count the number of cells in the range F$8$:F$20$ on the Detail worksheet where there is a match to the value in cell B$6$ on the Summary worksheet and where the value is less than $7.$

The function will count the number of rows where there is a match to the entry in cell B$6$ on the Summary worksheet in the range F$8$:F$20$ on the Detail worksheet and where the values in the range H$8$:H$20$ on the Detail worksheet are less than $7.$