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
ConernestoAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please try this...

=IF(G57=5471,SUMIFS(Sheet1!$G$1:$G$18,Sheet1!$B$1:$B$18,$F$2,Sheet1!$E$1:$E$18,"3952010",Sheet1!$C$1:$C$18,G56),0)

Open in new window

0
 
ConernestoAuthor Commented:
Thank you very much again.

Conernesto
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Conernesto!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.