#DIV/0! error for following formula

Hello,

Please help. I have the following formula in my spreadsheet:
=SUM(BF24/BE23+BF23+BG23+BH23))*30
I'm getting the the error #DIV/0!. How can I write the IF statement to change answer to 0, if error occurs?

Thank you
cstuckey56

Try

=IF(BE23=0,0,(BF24/BE23+SUM(BF23:BH23))*30)

Others:

=IF(ISERROR(SUM(BF24/BE23+BF23+BG23+BH23)*30),0,SUM(BF24/BE23+BF23+BG23+BH23)*30)

=IF(ERROR.TYPE(SUM(BF24/BE23+BF23+BG23+BH23)*30)=2,0,SUM(BF24/BE23+BF23+BG23+BH23)*30)

.