The following COUNTIFS function was entered into a cell on an Excel worksheet:

$=$COUNTIFS$($Detail$!$F$6$:F$18,$Summary!$\text{'}$A$7,$Detail!H$6$:H$18,"???$ing"$)$

Which of the following is true with regards to the criteria $2$ argument which is defined with $"???$ing"?

The function will produce an error output since this is not a valid way to define any of the criteria arguments in a statistical IFS function.

The function will search for any cells in the range $H6$:$H18$ on the Detail worksheet that contain the entry $"???$ing".

The function will search for any three contiguous cells in the range $H6$:$H18$ on the Detail worksheet that contains the letters "ing".

The function will search for any cells in the range $H6$:$H18$ on the Detail worksheet that contain an entry with six characters where the last three characters are the letters "ing".

The function will search for any cells in the range $H6$:$H18$ on the Detail worksheet that contain any entry with the letters "ing".