SUMIF does not work with closed targets - presumably OP has the file open while creating the formulae (shorthand link) but will close thereafter ?