Scotiabank interview question

Technical Part, Excel SUMIF functions, Vlookup