I'm trying to run a sumif to find blank or 0 cells in a column, and if found, give me the corresponding value in the adjoining cell. Normally I would use =SUMIF(AO5:AO344,"",AN5:AN344). However, Some cells in AN have a #DIV/0!, so the formula will not work. Any thoughts?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SUMIF ignore DIV/0 Error
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,971
- Office Version
- 365
- Platform
- Windows
Usually, the best bet is to address the error at its source instead of trying to work around it.
Is the #DIV/0! error the result of some formula?
If so, what is the formula? We can probably fix it up to avoid the error.
Is the #DIV/0! error the result of some formula?
If so, what is the formula? We can probably fix it up to avoid the error.
Upvote
0
Great thought. I just wrapped another formula in the iferror, and updated the errors to be 0's. This fixed my Sumif. Thanks!
Upvote
0
Similar threads
- Solved
