Yes Cutter, u r right. We have not yet been taught the functions like ' SUMIFS' and 'SUMPRODUCT' .

The assignment has been given under Lookup and Reference Functions Topic.