Sumif - Ignore Error one divide by 0

[maniacs205]

Hi

I am trying to do sumifs but I am getting 'Error Function DIVIDE parameter 2 cannot be zero', please check field J39:J43. It's because of a field that contains 1/0, which deters an infinite.

Please fill in row J24:J28 or replace field J39:J43 with the formula that will sum hence ignore the error.

https://docs.google.com/spreadsheets...EPE/edit#gid=0

Thank You

[TMS]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[maniacs205]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Sorry, I forgot to attached the Google Sheet, here https://docs.google.com/spreadsheets...EPE/edit#gid=0

Thanks

[TMS]

Use IFERROR to fix the Divide By Zero errors.

Please Login or Register  to view this content.

[MrShorty]

IMO, this kind of error is easier to trap in columns F and G rather than trapping it in the final SUMIFS() function. I would probably do something like =IFERROR(current formula,"error") in columns F and G to replace the error with a text string. Most spreadsheet functions (like SUMIFS()) will ignore text.

Would you be allowed to handle the errors in columns F and G, or are you required to trap the errors in column J?

[TMS]

IMO, this kind of error is easier to trap in columns F and G rather than trapping it in the final SUMIFS() function.

That's really what I had in mind.

[maniacs205]

Thank you guys, it's fixed now !

[TMS]

You're welcome. Thanks for the rep.