sumif are not an array and do not work properly without opening the referenced file.