Conernesto
asked on
SUMIFS formula add an additional condition
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.
SumIFS_3-three-criterias.xlsx
SumIFS_3-three-criterias.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome Conernesto!
ASKER
Conernesto