I have a sumifs Excel formula on the attached workbook in tab "2015 TrialBalance". I want to add a criteria to the formula. The criteria is if cell G57 is equal to 5471 sum the range. When I try to do this I get #value error. Can you help me to update the formula? The amount that should be on cell G5 is 292673. If you remove 5471 from cell G57, cell G5 should be zero.