a. Select cell E18.
b. Start the SUMIF function with cells $D$5:$D$14 as
the Range argument.
c. Set the Criteria argument as a relative reference to
cell C18.
d. Determine the Sum_range argument and make the
references absolute.