countblank giving a #DIV/0!

[reddirt]

I'm fairly new to Excel so any help would be greatly appreciated. I'm trying to add a quantity for each day and then have it divide by the remaing blanks. Having it give me a daily quanity needed to stay on track with my monthly goal.

I have this placed in B86
=B85/countblank(B51:B81)

Once I enter the last quantity into B81 I get a #DIV/0! in B86

 

[Caribeiro77]

Welcome to the board, that happen's cause when you enter a value in B81 you maybe don't have any more blanks from B51:B81 and you are dividing B85 by 0 resulting on a #DIV/0 error...

 

[reddirt]

Welcome to the board, that happen's cause when you enter a value in B81 you maybe don't have any more blanks from B51:B81 and you are dividing B85 by 0 resulting on a #DIV/0 error...

Is there a way to make it show 0 instead of #DIV/O

 

[Caribeiro77]

Try:

=iferror(B85/countblank(B51:B81),0)

 

[reddirt]

Try:

=iferror(B85/countblank(B51:B81),0)

Yes! Thank you, that done exactly what I wanted it to do.

 

[Caribeiro77]

Glad it helped...thanks for your feedback....