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

$=$ SUMIF$($Detail$!$$A$$2$:$A$$15,$Summary!A$6,$Detail!$G$2$:$G$20)$

Which of the following accurately explains which values will be summed when the function finds a match to the criteria?

Values in the range G$2$:G$20$ on the Summary worksheet will be summed.

Values in the range G$2$:G$20$ on the Detail worksheet will be summed.

Values in the range G$2$:G$15$ on the Detail worksheet will be summed.

Values in the range A$2$:A$20$ on the Detail worksheet will be summed.

Values in the range A$2$:A$15$ on the Detail worksheet will be summed.